Oracle10g - Xmlagg를 사용한 가로 Group by Query

SELECT B, REGEXP_REPLACE(XMLAGG(XMLELEMENT(C,A)).GETSTRINGVAL(), '<[C/]+>', '') A FROM ( SELECT 'A' A, '가' B FROM DUAL UNION ALL SELECT 'B' , '가' FROM DUAL UNION ALL SELECT 'C' , '가' FROM DUAL UNION ALL SELECT 'a' , '나' FROM DUAL UNION ALL SELECT 'B' , '나' FROM DUAL UNION ALL SELECT 'C' , '다' FROM DUAL) GROUP BY B 출처 : http://acidsound.blogspot.kr/2007/10/oracle10g-xmlagg-group-by-query.html http://neucareer.tistory.com/43...