Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14434 Views
- IBM, Zensar, I also Faced
- E-Mail Answers
Answer Posted / prativa mishra
select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//test()'),',') single_column
from table_name
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between cursor and trigger?
How to run sql functions in pl/sql?
What is procedure explain with example?
How is data stored in sql?
what are the 'mysql' command line arguments? : Sql dba
What is package in pl sql with an examples?
What is view? Can we update view
What is nosql example?
What are joins in sql?
Why do we use subquery?
What is clause in sql?
How do I delete a trigger?
What is sql*loader and what is it used for?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do I quit sql?
