I need to know how to pivot a single row of data.
I have a select statement that will always returns a single row of data with about 100 columns. I need to return instead a single column that has 100 rows. It is critical that I have the rows returned in an order controllable by the column names.
with t as (select 'a' as c1, 'x' as c2, 'm' as c3, 'w' as c4 from dual)
select * from t
I need to produce the following:
a
x
m
w
The following is NOT acceptable
a
m
w
x
Thanks,
Scott