select listagg(c1||','||c2,',') within group (

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 / sona mathew

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

Answer Posted / sona mathew

select listagg(c1||','||c2,',')
within group (order by c1||','||c2)
from tab;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to run sql statements with oracle sql developer?

1073

What is lexical units in pl sql?

1150

What is compute?

1095

What is sql injection owasp?

1069

explain commit and rollback in mysql : sql dba

1022

What are the types of keys?

996

What is the meaning of disabling a trigger?

1182

What is where clause in sql?

1042

What is the command used to fetch the first 5 characters of a string?

1209

What is query optimization in sql?

986

What is the use of partition by in sql?

996

What are some emotional triggers?

985

What is online transaction processing (oltp)?

1017

Explain the methods used to protect source code of pl/sql.

1022

What does dml mean?

993