Creating XML via the DB

Just some ways to produce XML from an Oracle DB using only SQL and PL/SQL. I'm sure this list is incomplete so I will expand it as I remember others. This is just what was coming to mind before writing this entry

• SQL/XML (XMLElement, XMLForest, XMLAgg)
• DBMS_XMLDOM
• XQUERY
• DBMS_XMLGEN
• DBMS_XMLQuery
• TRANSFORM/XMLTransform
• CreateXML/XMLType

Basically this serves as a reminder of what to cover in the future.