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

What is the difference between alter trigger and drop trigger statements?

1109

How can you save or place your msg in a table?

1001

What are the different types of functions in sql?

1055

Can dml statements be used in pl/sql?

1081

How exception handling is done in advance pl/sql?

981

How do I start sql from command line?

1025

Is primary key is clustered index?

1002

Explain lock escalation? : Transact sql

1198

Why sql query is slow?

1000

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1222

How long it takes to learn pl sql?

1010

Can we commit inside a trigger?

994

what is sql in mysql? : Sql dba

1196

What is a native sql query?

1072

What does a pl/sql package consist of?

976