我有一个像这样的表:
column1 column2 column3 column4
A B C D
想要将其转换为:
Column
A
B
C
D
在 oracle 中不使用此联合:
select column1 as Column from dual
union all
select column2 as Column from dual
union all
select column3 as Column from dual
union all
select column4 as Column from dual
您可以尝试使用unpivot http://www.oracle.com/technetwork/articles/sql/11g-pivot-097235.html
select v
from (
SELECT 'A' column1,'B' column2,'C' column3,'D' column4 from dual
) t
unpivot
(
v for val in (column1,column2,column3,column4)
) u;
sqlfiddle:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)