----> There is a table T with two columns C1 and C2.
The data is as below:
C1 C2
1 4
2 5
3 6
Answer Posted / bhanuprakash d
select listagg(c1,' ') within group (order by c1) from T
union
select listagg(c2,' ') within group (order by c2) from T
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can you create an empty table from an existing table? : Sql dba
What is transaction control language (tcl)?
How do you explain an index?
What is substitution variable?
What is multiple columns?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Explain the difference between rename and alias?
When you have to use a default "rollback to" savepoint of plvlog?
what are the performance and scalability characteristics of mysql? : Sql dba
What are the uses of merge?
Can pl sql procedure have a return statement?
Can you rollback after commit?
What are the different types of database management systems?
How do I count rows in sql?
How many commands are in sql?