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

Do ddl statements need commit?

540

What is the difference between delete, truncate and drop command?

552

What does the file extension accdb stand for?

549

How do you modify a column in sql?

536

how to get a list of all tables in a database? : Sql dba

513

What is difference between cursor and trigger?

559

How can you create an empty table from an existing table?

596

difference between anonymous blocks and sub-programs.

624

When is the explicit cursor used ?

588

How to prepare for oracle pl sql certification?

569

What is the use of triggers?

545

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

1593

How can we link a sql database to an existing android app?

550

What is difference between procedure and trigger?

519

How many developers work on postgresql?

566