SQL> select
2 xmlelement( "emp",
3 xmlagg( xmlelement( "name", emp_name )))
4 from emp;
XMLELEMENT("EMP",XMLAGG(XMLELEMENT("NAME",EMP_NAME)))
------------------------------------------------------------------------------
<EMP><NAME>なまえ1</NAME><NAME>なまえ2</NAME><NAME>なまえ3</NAME></EMP>
|