* 한 컬럼 중복제거 후 이어 붙이기 SELECT LAW_ID, SUBSTR(XMLAGG(SYS.XMLTYPE.CREATEXML(',' || CONTRACT_GESTALT||'') ORDER BY CONTRACT_GESTALT).EXTRACT('/a1/text()'), 2) CONTRACT_GESTALT, SUBSTR(XMLAGG(SYS.XMLTYPE.CREATEXML(',' || MEMO1||'') ORDER BY MEMO1).EXTRACT('/a1/text()'), 2) MEMO1 FROM ( SELECT LAW_ID, CONTRACT_GESTALT,NVL2(CONTRACT_GESTALT, 'a' || ROW_NUMBER() OVER (PARTITION BY LAW_ID, CONTRACT_GESTAL..