Oracle把一列的值合併爲一個值並用逗號分隔

https://www.twblogs.net/a/5b8b1f0b2b717718832d71fb


SELECT D.DEPTNO AS 部門編號,D.DNAME AS 部門名稱,WMSYS.WM_CONCAT(E.ENAME) AS 員工列表 FROM DEPT D LEFT JOIN EMP E ON D.DEPTNO = E.DEPTNO GROUP BY D.DEPTNO,D.DNAME