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 a delimiter in sas?

728

Is oracle sql free?

726

What is the use of function "module procedure" in pl/sql?

879

Can %notfound return null after a fetch?

754

How to prepare for oracle pl sql certification?

776

What is sql in oracle?

791

How do you know if a relationship is 2nf?

685

What is transaction control language (tcl)?

844

What is pl sql collection?

689

where are cookies actually stored on the hard disk? : Sql dba

783

What is data modelling in sql?

707

Explain the difference between 'between' & 'and' operators in sql

718

Is json a nosql?

720

What is java sql package?

732

How many triggers can be applied to a table?

775