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

Why schema is used in sql?

1089

What is autocommit sql?

1044

How to make a copy values from one column to another in sql?

1084

Can we group by two columns in sql?

1046

What will you get by the cursor attribute sql%found?

1009

How do I view a procedure in sql?

1019

Write a query to find the names of users that begin with "um" in sql?

1045

How to convert comma separated string to array in pl/sql?

1242

What is dba in sql? : SQL DBA

1095

What is the best sql course?

1028

How do you remove duplicates without using distinct in sql?

1019

What is relationship? How many types of relationship are there?

1264

What is update query?

1035

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1228

What is write ahead logging in sql server?

1101