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.
- 8 Answers
- 12046 Views
- IBM, Zensar, I also Faced
- E-Mail Answers
Answer Posted / sunaksha
select listagg( A||','||B || ',') within group (order by A) from table_name;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What can I use instead of union in sql?
Does sql view stored data?
How do I install microsoft sql?
Mention what are the benefits of pl/sql packages?
What is difference between cursor and trigger?
What is the requirement of self-join?
What is the difference between the sql*loader and import utilities? : aql loader
What is a record in pl/sql?
How do I run sql profiler?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
what are sequences
What is the advantage of nosql?
How to use distinct and count in sql query? Explain
What is a memo field?
What is procedure in pl sql?
