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

Why do we need cursor in pl sql?

1076

What is a composite primary key?

1030

Which are the different character-manipulation functions in sql?

983

how to get a list of indexes of an existing table? : Sql dba

913

Can we rollback after truncate?

979

What is microsoft t sql?

879

how would you enter characters as hex numbers? : Sql dba

933

Are there any features that are decommissioned in 11g that are not present in 11g?

2064

Can we have two clustered index on a table?

963

What is the difference between explicit and implicit cursors in oracle?

996

What is int identity in sql?

1054

Is merge a dml statement?

921

What is implicit cursor in pl sql?

1023

What does bitemporal mean?

1008

How does postgresql compare to mysql?

984