select rtrim(xmlagg(xmlelement(E, EMPID||','||NAME||','

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 / krishna

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

Answer Posted / krishna

select rtrim(xmlagg(xmlelement(E,
EMPID||','||NAME||','||'')).extract('//text()') ,',')
empid from emp1

Is This Answer Correct ?

7 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to place comments in pl/sql?

1218

How to write html code in pl sql?

1161

Which data dictionary views have the information on the triggers that are available in the database?

1301

What operating systems are supported by oracle sql developer?

1016

Can you join views in sql?

996

What is the difference between sql, mysql and sql server?

1177

How do we use distinct statement? What is its use?

1076

what is csv? : Sql dba

1051

Is subquery faster than join?

1063

How do you update a value in sql?

1103

Can a table have no primary key?

1112

How do I view a sql trace file?

1063

Can you call pl/sql package functions from within a fast formula?

1086

How can you tell the difference between an index and a view?

978

How do I create a sql script?

1143