select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',&

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 / prativa mishra

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

Answer Posted / prativa mishra

select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//text()'),',') single_column
from table_name

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to raise user-defined exception with custom sqlerrm ?

1129

How to install oracle sql developer?

1046

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

980

What is the mutating table and constraining table?

1026

How to disable a trigger name update_salary?

1266

What does the hierarchical profiler does?

1058

explain access control lists. : Sql dba

1002

How do I view a procedure in sql?

974

What are the different dml commands in sql?

1176

What does pl sql developer do?

932

define sql update statement ? : Sql dba

1123

Is postgresql a server?

1055

How many types of privileges are available in sql?

1350

What are all the different normalizations?

1033

What does dml mean?

988