I have a piece of code
select
RTRIM(xmlagg(xmlelement(en, empno,'.')) ||',')).EXTRACT('//text()').EXTRACT('//text()') ,',');
from employees
Can somebody please help me understand what xmlagg, xmlelement and extract does?
Thanks. :)
Edited by: Termite_paste on Aug 14, 2012 5:10 AM