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
14731 Views
IBM, Zensar, I also Faced
E-Mail Answers

Answer Posted / prativa mishra

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the uses of control file.

1101

What is a memo field?

1019

Is left join faster than join?

1096

How to create a menu in sqlplus or pl/sql?

1171

How do I find sql profiler?

992

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1167

What are the different tcl commands in sql?

1232

How to read/write files from pl/sql?

1085

tell me about various levels of constraint. : Sql dba

1078

What are synonyms in sql?

1027

What is a relationship and what are they?

1230

Explain the difference between 'between' & 'and' operators in sql

1046

Why do we need view in sql?

1039

Define commit?

1053

Can we use update in sql function?

1116