버전별 문자열 합치기
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, '..