Prev: Oracle 10g on Solaris 10 non-global zones with asynchronous I/O
Next: Network Configuration Assistant error
From: webtourist on 25 Mar 2010 15:58
solution found:

SELECT deptno,
substr(REPLACE(REPLACE(xmlagg(xmlelement("x", job) ORDER BY
job), '</x>'), '<x>', ' '), 2) job_list,
wmsys.wm_concat(DISTINCT job) job_list_distinct
FROM emp
GROUP BY deptno
ORDER BY deptno



I win :)
First  |  Prev  | 
Pages: 1 2
Prev: Oracle 10g on Solaris 10 non-global zones with asynchronous I/O
Next: Network Configuration Assistant error