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

what is the difference between cluster and non cluster index? : Sql dba

1036

define sql update statement ? : Sql dba

1127

What is rollback?

1119

How do you update sql?

994

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

1097

What is clustered index in sql?

1058

what are the drivers in mysql? : Sql dba

1028

What is the basic structure of an sql?

1114

How to change the order of columns in Oracle SQL Plus ?

1059

what is transaction? : Sql dba

1014

How global cursor can be declare with dynamic trigger ?

2216

how to extract a unit value from a date and time? : Sql dba

999

What is data abstraction in sql?

1036

Explain the purpose of %type and %rowtype data types?

940

What are the different types of a subquery?

1057