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

How to avoid duplicate records in a query?

588

What is trigger explain it?

555

what are tables and fields? : Sql dba

586

Can we connect to postgresql using sql developer?

495

what are null values? : Sql dba

550

When you have to use a default "rollback to" savepoint of plvlog?

736

What are different types of triggers?

573

How do you copy a table in sql?

572

what are all different types of collation sensitivity? : Sql dba

533

What is ttitle and btitle?

586

What is composite data type in pl sql?

568

what is the use of double ampersand (&&) in sql queries?

635

Which function is used to return remainder in a division operator in sql?

592

What is the difference between the sql*loader and import utilities? : aql loader

608

What is sql rowcount?

567