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 are all the different types of indexes?

707

What is t sql used for?

629

What is cross join example?

641

What are views in sql?

639

what is the difference between delete and truncate commands? : Sql dba

630

What is an exception in PL/SQL? What are the two types of exceptions?

732

What is t sql in sql server?

652

What is input buffer in sql*plus?

726

What does the base_object_type column shows in the user.triggers data dictionary view?

660

What is the non-clustered index in sql?

664

how can we submit a form without a submit button? : Sql dba

629

What is group function in sql?

641

What is a natural join sql?

599

how to start mysql server? : Sql dba

737

What is a common use of group by in sql?

698