Get the XML out of your database

Get the XML out of your database: "'How do I get my XML document out of the database?' This is the second most common question I get. It's usually followed up with 'My DBA is afraid to use any feature added since 7.3 (or 8 or 8i, etc) so I am not allowed to use WebDAV, the internal HTTP server or Java in the database.' This is usually followed by me laughing hysterically and crying at the same time. Been there, done that, got the t-shirt."