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
14727 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 to install oracle sql developer?

1098

What is foreign key sql?

1041

what is bdb (berkeleydb)? : Sql dba

1093

What is sql prepared statement?

1036

What are aggregate and scalar functions?

1090

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1086

How do you use collections in procedure to return the resultset?

2286

What is sqlite used for?

1048

How many types of cursors are available in pl/sql?

1167

How delete all data from table in sql?

1077

What is parameter substitution in sql?

1081

How can one get sql*loader to commit only at the end of the load file? : aql loader

1119

What are types of joins?

1030

What is the most restrictive isolation level? : Transact sql

1128

How do I save a sql query?

1067