select replace(wm_concat(c1),',',' '),replace(wm

----> There is a table T with two columns C1 and C2.
The data is as below:
C1 C2
1 4
2 5
3 6

Question Posted / nihar meher

Answer Posted / nihar meher

select replace(wm_concat(c1),',',' '),replace(wm_concat(c2),',',' ') from t;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is there any restriction on the use of union in embedded sql?

1164

How can I tell if sql is running?

1072

How do you exit in sql?

1114

What does the acronym acid stand for in database management?

1040

Which normal form is best?

953

How to prepare for oracle pl sql certification?

1075

Write a sql select query that only returns each name only once from a table?

1025

What is procedure function?

1071

Explain the rollback statement?

1016

Show the cursor attributes of pl/sql.

1059

What are sql queries used for?

1033

Is hadoop a nosql?

1011

What is difference between function and trigger?

1058

What is cursor status?

1193

How to avoid duplicate records in a query?

1013