合并前SQL:
SELECT DE.I_NAME_DESC FROM AT_PO_PROC_TR PROC,T_DESC_MS DE WHERE DE.I_CLS_CD = '063' AND DE.I_NAME_CD = PROC.I_IND_CONTENT AND PROC.I_PO_DETAIL_NO = '1705002877';
合并后:
SELECT LISTAGG(DE.I_NAME_DESC,',') within group ( order by de.i_name_cd ) FROM AT_PO_PROC_TR PROC,T_DESC_MS DE WHERE DE.I_CLS_CD = '063' AND DE.I_NAME_CD = PROC.I_IND_CONTENT AND PROC.I_PO_DETAIL_NO = '1705002877';