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

Is id a reserved word in sql?

1090

What is sql and db2?

941

What are schema-level triggers?

1045

Explain locks? : Transact sql

950

What is left join example?

888

What are the types of subqueries?

1014

What is a memo field?

900

How do you delete a table?

996

Can we create foreign key without primary key?

931

What do you mean by table in sql?

936

What is cursor and why it is required?

1105

What is mutating table error?

1115

Whis is not false in primary key?

1401

What is the use of nvl function?

1123

What are different types of sql?

1098