SQL> select
2 xmlelement( emp,
3 xmlattributes( emp_id as id ),
4 xmlforest( emp_name as name, salary as sal ))
5 from emp;
XMLELEMENT(EMP,XMLATTRIBUTES(EMP_IDASID),XMLFOREST(EMP_NAMEASNAME,SALARYASSAL))
--------------------------------------------------------------------------------
<EMP ID="E01"><NAME>なまえ1</NAME><SAL>150</SAL></EMP>
<EMP ID="E02"><NAME>なまえ2</NAME><SAL>200</SAL></EMP>
<EMP ID="E03"><NAME>なまえ3</NAME></EMP>
|