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
14471 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

Is a foreign key always unique?

942

What is the difference between alter trigger and drop trigger statements?

1107

What is crud diagram?

947

What are the usages of sql?

1058

What is difference between hql and sql?

1077

Why do we go for stored procedures?

1057

How do you optimize a stored procedure query?

998

How to change sql*plus system settings?

1054

how many groups of data types? : Sql dba

1026

What is schema in sql example?

1178

what is oltp (online transaction processing)? : Sql dba

1077

Show code of a cursor for loop.

1054

What is union?

1167

What is coalesce sql?

997

How many clustered indexes can you have?

973