www.oradev.com
  Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages
How to transform a query to XML

Packages

dbms_lob
dbms_output
How to use utl_http
Transform query to XML
Scheduling in 10g
dbms_profiler explained


  OraDev.com

Transform query to XML

Oracle has neat standard functionality to transform a query to qml. Sample code:
 select dbms_xmlgen.getxml(íselect * from user_tablesí)
 from dual;