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;