오라클(oracle) 그룹함수(group by) String 그룹핑 하기

WITH TBDTMEPCD AS ( SELECT '대법원' JOSO, '00001' P_CODE, '원고' P_NAME FROM DUAL UNION ALL SELECT '대법원' JOSO, '00001' P_CODE, '피고' P_NAME FROM DUAL UNION ALL SELECT '대법원' JOSO, '00002' P_CODE, '원고' P_NAME FROM DUAL UNION ALL SELECT '대법원' JOSO, '00003' P_CODE, '원고' P_NAME FROM DUAL ), TBDTMEPCD2 AS( SELECT rownum as rn,JOSO,P_CODE,P_NAME FROM TBDTMEPCD )select JOSO,P_CODE, LISTAGG( P_NAME , ':') WITHIN group (ORDER BY NULL) from TBDTMEPCD2 group by JOSO,P_CODE;