select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',&

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 / prativa mishra

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

Answer Posted / prativa mishra

select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//test()'),',') single_column
from table_name

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between count 1 and count (*) in a sql query?

908

How do I copy a table in sql?

928

what is the difference between where clause and having clause? : Sql dba

948

What type of database is sql?

978

Can we use pl sql in sql server?

1012

Can triggers stop a dml statement from executing on a table?

1024

What are pl/sql packages?

1035

How do you update f as m and m as f from the below table testtable?

1789

What will you get by the cursor attribute sql%found?

899

what is csv? : Sql dba

945

Does sql profiler affect performance?

940

What packages(if any) has oracle provided for use by developers?

5716

What is multiple partition?

920

Is a secondary key the same as a foreign key?

953

What are tables and fields in the database?

1023