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.
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
What is bitemporal narrowing?
what are the differences between char and nchar? : Sql dba
Why are sql stored procedures used?
What is the use of nvl function?
What are the different types of tables in sql?
How to Execute a Package in PL/SQL.?
How many unique keys can a table have?
Explian rowid, rownum?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is lookup table in sql?
What is cte sql?
What is the order of sql select?
Why do we use %rowtype & %type in plsql?
Why we use stored procedure instead of query?
How do I truncate a sql log file?