oracle单列转行,oracle 两种列转行的方式

oracle两种列转行的方式

select  baseItem.SUIT_TO, wmsys.wm_concat(to_char(dict.DICT_VALUE)) as dicv

from T_STUM_SS_BASE_ITEM baseItem

inner JOIN BLADE_DICT dict on dict.CODE='PYCC'

and instr(CONCAT(',',CONCAT(to_char(baseItem.SUIT_TO),',')),CONCAT(',',CONCAT(to_char(dict.DICT_KEY),',')))>0

GROUP BY   baseItem.SUIT_TO

select  baseItem.SUIT_TO,listagg(to_char(dict.DICT_VALUE),',') within group (order by dict.DICT_VALUE) as dicv

from T_STUM_SS_BASE_ITEM baseItem

inner JOIN BLADE_DICT dict on dict.CODE='PYCC'

and instr(CONCAT(',',CONCAT(to_char(baseItem.SUIT_TO),',')),CONCAT(',',CONCAT(to_char(dict.DICT_KEY),',')))>0

group by  baseItem.SUIT_TO