Ever wished that Oracle had something like SQL Server's FOR XML and OPENXML keywords?  It doesn't have it, but you can return XML from Oracle as a CLOB using XSU, and shred an XML string into relational tables using the XMLType. For more information:

Thanks to Sreedhar for this tip.