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 低
select '2','中' from dual union all
select '3','低' from dual;
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 低