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 output spooling in sql*plus?

1030

What is the best free sql database?

1049

How do you run a query?

989

What trigger means?

974

what is the difference between $message and $$message? : Sql dba

995

What is the difference between subquery and correlated query?

1063

when MSQL8.0 is in market

2074

What do you mean by dbms? What are its different types?

1011

Explain the difference between triggers and constraints?

967

what are different types of keys in sql?

1145

What is sqlcommand?

1026

What is the difference between having and a where in sql?

1101

What is %s in sql?

1009

What is sqlite used for?

992

Can dml statements be used in pl/sql?

1073