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
14426 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 long does it take to learn pl sql?

1053

What is clustered and nonclustered index in sql?

935

How to download oracle sql developer?

1093

Why do we use joins?

1030

how to decrement dates by 1 in mysql? : Sql dba

1011

What is the difference between partitioning and sharding?

1003

explain access control lists. : Sql dba

990

How delete all records from table in sql?

974

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

955

How do you create a db file?

1007

How to rename a column in the output of sql query?

1068

What is cursor and its types?

1059

What is indexing in sql and its types?

1070

Mention what are the benefits of pl/sql packages?

1072

How can you load microsoft excel data into oracle? : aql loader

1167