Thursday, September 17, 2015

Oracle Converting Oracle rows to columns

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


Yasser

No comments:

Post a Comment