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
14353 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 is a common use of group by in sql?

1027

What is trigger types of trigger?

1045

What is a sql instance vs database?

1100

What are the types of records?

977

how to analyze tables with 'mysqlcheck'? : Sql dba

993

What is sql analyzer?

995

What is the difference between an inner and outer join?

998

What's the difference between a primary key and a clustered index?

975

What does joining a thread mean?

1001

Can you join a table to itself?

1106

What are the advantages of normalization?

1065

Is null operator in sql?

1010

Explain what is a column in a table?

1084

Why we use triggers in mysql?

978

What is join view in sql?

930