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

Does varchar need length?

995

Explain the rollback statement?

1013

Explain autonomous transaction.

1156

What is memory optimized?

1087

What is the difference between a database and a relational database?

1103

What is cte sql?

997

What is difference between primary and secondary key?

1028

What are tables in sql?

1066

how to shut down the server with 'mysqladmin'? : Sql dba

1012

What is break?

1198

Is null operator in sql?

1041

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1829

what is a composite key ? : Sql dba

1062

What is varchar sql?

1145

What are different categories of sql commands?

1133