Oracle行转列函数

listagg() WITHIN GROUP ()

SELECT    T .DEPTNO,    listagg (T .ENAME, ',') WITHIN GROUP (ORDER BY T .ENAME) namesFROM    SCOTT.EMP TWHERE    T .DEPTNO = '20'GROUP BY    T .DEPTNO