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
14415 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 a table partition?

1120

What is flag in sql?

1026

What are the benefits of triggers?

1164

Which language is used in sql?

1048

What are different types of tables in sql?

990

what is the difference between myisam static and myisam dynamic? : Sql dba

1054

How to create a menu in sqlplus or pl/sql?

1113

What is a stored procedure in sql with example?

1113

How do I remove duplicates in two columns?

1047

What is the difference between Union and Union all. Which is faster.

1396

How do you write a complex sql query?

1050

Is sql the best database?

963

Where not exists in sql?

970

What is the difference between clustered and non-clustered index in sql?

1003

What are types of joins?

958