学步园

SELECT DEPTNO, LTRIM(SYS_CONNECT_BY_PATH(ENAME, ','), ',') AS P
  FROM (SELECT DEPTNO,
               ENAME,
               ROW_NUMBER() OVER(PARTITION BY DEPTNO ORDER BY EMPNO) AS SN,
               COUNT(*) OVER(PARTITION BY DEPTNO) AS CT
          FROM SCOTT.EMP)
 WHERE SN = CT
 START WITH SN = 1
CONNECT BY PRIOR DEPTNO = DEPTNO
       AND PRIOR SN = SN - 1

DEPTNO P
------ ----------------------------------------
    10 CLARK,KING,MILLER
    20 SMITH,JONES,SCOTT,ADAMS,FORD
    30 ALLEN,WARD,MARTIN,BLAKE,TURNER,JAMES