WMSYS.WM_CONCAT

/* 여러 개의 row를 한 개 row, column 으로 변환 */ SELECT WMSYS.WM_CONCAT(A.COL1) RET_VAL FROM  (     SELECT 'A' COL1 FROM DUAL UNION ALL     SELECT 'B' COL1 FROM DUAL UNION ALL     SELECT 'C' COL1 FROM DUAL UNION ALL     SELECT 'D' COL1 FROM DUAL UNION ALL     SELECT 'E' COL1 FROM DUAL ) A; --RET_VAL => A,B,C,D,E