SQL> select
2 sys_xmlagg( sys_xmlgen( salary ),XMLFormat('emp'))
3 from emp;
SYS_XMLAGG(SYS_XMLGEN(SALARY),XMLFORMAT('EMP'))
---------------------------------------------------------------
<?xml version="1.0"?>
<emp>
<SALARY>150</SALARY>
<SALARY>200</SALARY>
</emp>
|