select WM_CONCAT(a||','||b) from tablename;

have table with two columns with datatypes as number and
varchar and the values in
A column like 1,2,3 AND B column values like a,b,c.
now need to display data in a single column as 1,a,2,b,3,c.

Question Posted / kavitha neditunta

8 Answers
14506 Views
IBM, Zensar, I also Faced
E-Mail Answers

Answer Posted / kavitha neditunta

select WM_CONCAT(a||','||b)
from tablename;

Is This Answer Correct ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many times can we commit in a loop?

1029

How can you fetch common records from two tables?

1066

Can we rollback delete command?

996

How are sql commands classified?

1096

What are sql built in functions?

947

How do you sort in sql?

1034

what is the difference between $message and $$message? : Sql dba

1006

Can we insert in view in sql?

1070

How do I partition in sql?

970

How to use transactions efficiently : transact sql

1064

What does trigger mean in psychology?

971

What is transaction control language (tcl)?

1145

What does joining a thread mean?

1024

Is sql considered coding?

1050

How can I see all tables in sql?

1084