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;
oracle 自定义数据行变多列(connect by level)
最新推荐文章于 2024-07-22 16:03:25 发布
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;