Exporting Table Data as Oracle XML

If you are using dbms xmlsave, you might want to capture data from a table into Oracle's format as well. This is actually very straightforward with dbms_xmlgen.

SELECT dbms_xmlgen.getXml(
  'SELECT *
     FROM your_table_name_goes_here'
  , 0
  ) FROM dual;