다중 Row 결과를 단일행으로 컴마로 분리해 출력하는 방법

SELECT     SUBSTR (MAX (SYS_CONNECT_BY_PATH (ename, ',')), 2) path#

FROM       (SELECT ename, ROWNUM rnum

            FROM   emp)

START WITH rnum = 1

CONNECT BY PRIOR rnum = rnum - 1

 

 

 

SELECT     deptno, SUBSTR (MAX (SYS_CONNECT_BY_PATH (ename, ',')), 2) path#

FROM       (SELECT ename, deptno, ROW_NUMBER () OVER (PARTITION BY deptno ORDER BY ename) rnum

            FROM   emp)

START WITH rnum = 1

CONNECT BY PRIOR rnum = rnum - 1

AND        PRIOR deptno = deptno

GROUP BY   deptno