http://www.gurubee.net/article/55512

ListAgg(name, ',') WITHIN GROUP(ORDER BY code) name_11g


WITH t AS
(
SELECT '이름' type, '홍길동' name, '0' code FROM dual
UNION ALL SELECT '이름', '김길동', '1' FROM dual
UNION ALL SELECT '이름', '최길동', '2' FROM dual
)
SELECT  ListAgg(name, ',') WITHIN GROUP(ORDER BY code) name
--ListAgg ~ within group 함수는 컬럼을 한줄로 나오게 표현하는것
FROM t
GROUP BY type
ORDER BY type
;
 
WITH t AS
(
SELECT '이름' type, '홍길동' name, '0' code FROM dual
UNION ALL SELECT '이름', '김길동', '1' FROM dual
)
SELECT ListAgg(name, ',') WITHIN GROUP(ORDER BY code) name
FROM t
GROUP BY type
ORDER BY type
;