How to Generate XML Data from the Database
April 27th, 2006 By Eddie Awad
You can generate XML from the database using:
- Standard SQL/XML Functions:
- XMLELEMENT
- XMLATTRIBUTES
- XMLFOREST
- XMLCONCAT
- XMLAGG
- XMLPI
- XMLCOMMENT
- XMLROOT
- XMLSERIALIZE
- XMLPARSE
- Oracle Database SQL Functions:
- XMLSEQUENCE
- XMLCOLATTVAL
- XMLCDATA
- SYS_XMLGEN
- SYS_XMLAGG
- DBMS_XMLGEN
- XSQL Pages Publishing Framework
- XML SQL Utility (XSU)
- DBURIType
Some of the options above may not be available in versions of the Oracle database earlier than 10g Release 2 (10.2).
For more details on each of the above options check out:
- Oracle XML DB Developer’s Guide 10g Release 2 (10.2) - Chapter 16
- Oracle9i XML Database Developer’s Guide - Oracle XML DB Release 2 (9.2) - Chapter 10
Related links:
- Producing XML from SQL using cursor expressions
- XML in the Database: A Brief Overview
- Get the XML out of your database
- XE, XML and WebDAV - Access your XML data in Oracle XE
- XML and OO in Oracle, A Scenario
If you have any additional XML resources, please add them in the comments below.