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

What are sql functions? Describe the different types of sql functions?

1053

How can I tell if sql is running?

988

Why do we use procedures in pl sql?

957

how to drop an existing index in mysql? : Sql dba

1016

What are the different types of dbmss?

960

what is rdbms? : Sql dba

958

Should I use mbr or gpt?

938

What is a primary key example?

899

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

986

What is the primary key?

876

What port does sql server use?

984

What is the difference between microsoft sql and mysql?

919

What is a .db file?

925

What are the advantages of indexing?

926

What is an invalid partition table?

958