Oracle row-to-column function

Shulou Source: shulou.com Published: 2022-06-01 22:14:38 09月28日 Update

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