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
14091 Views
IBM, Zensar, I also Faced
E-Mail Answers

Answer Posted / prativa mishra

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

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How subquery works in sql?

995

Is pl sql and postgresql same?

1053

What are the different types of tables in sql?

929

Does inner join remove duplicates?

884

Is hadoop a nosql?

949

Explain table and field in sql?

1015

What is the difference between microsoft sql and mysql?

920

Why is there a need for sqlcode and sqlerrm variables?

996

How does one load ebcdic data? : aql loader

1093

What is the difference between between and in condition operators?

939

What is the difference between drop and truncate commands?

997

What is example of database?

985

What is record type in pl sql?

936

what is a trigger in mysql? Define different types of trigger. : Sql dba

1010

What is index example?

950