SELECT deptno , SUBSTR( XMLAGG(XMLELEMENT(x, ',', ename) ORDER BY empno).EXTRACT('//text()') , 2) enames_9i
, wm_concat(ename) enames_10g
, LISTAGG(ename, ',') WITHIN GROUP(ORDER BY empno) enames_11g
FROM emp GROUP BY deptno ORDER BY deptno ;SELECT deptno
, SUBSTR( XMLAGG(XMLELEMENT(x, ',', ename) ORDER BY empno).EXTRACT('//text()') , 2) enames_9i
, wm_concat(ename) enames_10g
, LISTAGG(ename, ',') WITHIN GROUP(ORDER BY empno) enames_11g
FROM emp
GROUP BY deptno
ORDER BY deptno ;