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.
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
What is a temporal data type?
Why self join is used in sql?
how to convert numeric values to character strings? : Sql dba
What is the execution plan in sql?
What is the difference between a query and a report?
How do I add a database to sql?
what is myisam? : Sql dba
What does joining a thread mean?
How many parts of a pl sql block are optional?
Write a sql select query that only returns each name only once from a table?
Which type of cursor is used to execute the dml statement?
Why do we use subquery?
How do you truncate?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What does subquery mean in sql?