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

What are the two types of periodical indexes?

923

What are keys in sql?

978

what is a trigger in mysql? Define different types of trigger. : Sql dba

1051

How can you select unique records from a table?

1051

Explain what is a subquery ?

1166

How to rename a column in the output of sql query?

1063

how to convert character strings to dates? : Sql dba

1040

Explain the types of joins in sql?

1014

explain the difference between bool, tinyint and bit. : Sql dba

975

Is foreign key mandatory?

985

What is pl/sql language case sensitive?

1103

what is bcp? When is it used?

1091

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

936

how to select unique records from a table? : Sql dba

1091

what are properties of a transaction? : Sql dba

1076