求助：oralce中怎么一行转成一列利用dual构建虚表“select 1,高,2,中,3,低 from dual”如下：需要
求助：oralce中怎么一行转成一列
利用dual构建虚表 “select '1','高','2','中','3','低' from dual” 如下：
需要等到结果：
等级代码 等级
1 高
2 中
3 低
java oralce
[解决办法]
select '1','高' from dual union all
select '2','中' from dual union all
select '3','低' from dual;
[解决办法]
sys@ORCL> ed
Wrote file afiedt.buf
1 with
2 t as (
3 select '1' "等级代码",'高' "等级" from dual union all
4 select '2','中' from dual union all
5 select '3','低' from dual
6 )
7* select * from t
sys@ORCL> /
等级代码 等级
-------------------- --------------------
1 高
2 中
3 低