Oracle в XML

SET HEADING OFF;
SET FEEDBACK OFF;
spool /opt/tmp/apartments.xml;
SELECT '  <apartment>
<id>' || id || ' </id>
<numberobj>' || numberobj || '</numberobj>
<rka>' || full_rka || '</rka>
<kadno>' || kad_no || '</kadno>
<actual>' || DECODE(actual, 1, 'true', 'false') || '</actual>
<modified>' || modified|| '</modified>
<buildingid>' || building_id || '</buildingid>
<categorybuildingid>' || categorybuilding_id || '</categorybuildingid>
</apartment>' FROM apartments;
spool off;