#1295

[Oracle] Row to Column conversion

select 
   deptno,
   rtrim (xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames
from 
   emp
group by 
   deptno

Olivier says:

To sort the elements :

SELECT
rtrim (xmlagg (xmlelement (e, ename || ',') ORDER BY ENAME DESC ).extract ('//text()'), ',') AS ORDERED_ENAMES
FROM ...