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

what are the different tables present in mysql? : Sql dba

980

What is asqueryable?

961

Difference between truncate, delete and drop commands?

1080

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1003

Why we use pl sql?

955

What is the difference between partition and index?

979

What is multiple partition?

962

Which is better cte or subquery?

1026

Does sql full backup truncate logs?

1012

what is data control language? : Sql dba

1017

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1061

How do I remove sql plus from windows 10?

1088

What are stored procedures used for?

997

Explain the the update statement in sql?

1030

Are stored procedures faster than dynamic sql?

1026