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

How can we avoid duplicating records in a query?

984

What is attribute indicator in pl sql?

1017

Is inner join faster than left join?

1191

what are the join types in tsql? : Transact sql

1064

What is write ahead logging in sql server?

1055

How do I run pl sql in sql developer?

1120

What is the difference between sql and t sql?

1042

How do you optimize a query?

1007

What is scalar function in sql?

1044

how to enter binary numbers in sql statements? : Sql dba

977

Can a foreign key have a different name?

941

When is a declare statement required?

1144

What are the uses of sysdate and user keywords?

1105

What is the usage of nvl function?

1040

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1193