Converting multiple column in single column
Hi All,
I need to create a table with single column by using select statement with multiple columns
For Ex- i have 1 row with 10 columns (may be more than 10) like
'A','B','C','D','E','F','G','H',I','J'
i written sql like
select 'A','B','C','D','E','F','G','H','I','J' from dual
result is - 'A','B','C','D','E','F','G','H','I','J' with 10 columns
Now i need output lik this using SQL
Text
------
'A'
'B'
'C'
'D'
'E'
'F'
'G'
'H'
'I'
'J'
Please help me to sort out this problem. Your help would highly appropriated.
Regards
Raju
Edited by: 888667 on Apr 8, 2013 10:54 PM
Edited by: 888667 on Apr 8, 2013 10:56 PM