oracle 自定义数据行变多列(connect by level)

select decode(level,
1,
‘TYPE_01’,
2,
‘TYPE_02’,
3,
‘TYPE_03’,
4,
‘ETYPE_4’,
5,
‘TYPE_5’) use_obj
from dual
connect by level <= 5;

©️2020 CSDN 皮肤主题: 技术黑板 设计师:CSDN官方博客 返回首页