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

Is ms sql traffic encrypted?

963

How do I start pl sql?

998

Explain how can you save or place your msg in a table?

1078

What is a scalar value in sql?

1126

What is oracle sql called?

979

what is the command line end user interface - mysql? : Sql dba

1031

How do you write a complex sql query?

1142

What is the difference between drop and truncate commands?

1114

What does count (*) mean?

986

What are procedures used for?

1038

What is pl sql architecture?

1007

How many types of cursors are available in pl/sql?

1167

What is sqlite used for?

1049

How do you add a column to a table?

1106

What is database migration?

1013