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 / 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 collation? : Sql dba
What is basic structure of pl sql?
How long does it take to learn pl sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is the non-clustered index in sql?
how to include comments in sql statements? : Sql dba
What is a temporal table?
Can a select statement fire a trigger?
How to handle bulk data?
Is sql microsoft?
What is data type in sql?
How can the performance of a trigger be improved?
How do you create a db file?
How we can update the view?