Generating XML from SQL Data with DBM XMLGEN

DBMS_XMLGEN is a PL/SQL package supplied in Oracle Database 10g to generate XML in CLOBs or XMLTypes. It is a C-based implementation, which provides much better performance than the Java-based DBMS_XMLQUERY package in the Oracle8i and Oracle9i database. While DBMS_XMLGEN provides similar functionality to the SQL/XML functions, it is most useful when you need to

• Utilize the “fetching” interfaces in DBMS_XMLGEN for pagination

• Perform PL/SQL processing during the XML document generation