Brilliant use of XML in the relational database

A great example of how one could use the Oracle XMLDB functionality in a unforeseen way in your relational world, is being demonstrated by Laurent Schneider in his article “How do i store the counts of all tables…

Here, Laurent demonstrates the alternative use of XML functions and packages to solve intriguing and demanding queries. Have a look yourself at Laurent’s site at http://laurentschneider.com

Another small addition…
Apparently I overlooked the XML items filed under “csv format with select *“, but luckily Tom Kyte re-directed my attention to it…
As said, Cool stuff

 

4 thoughts on “Brilliant use of XML in the relational database

  1. Marco,

    I recently found this site: http://www.sqlsnippets.com. Joe Fuda shows some interesting usages of the XML functions. I found the usage of the xmlagg function to convert rows to strings exceptionally useful.

    Leon

Comments are closed.

Next Post

AMIS Academy - Mini Conference on Oracle, Java, SOA, Process Analysis, Database, Application Server and BI

Facebook0TwitterLinkedinTuesday May 8th we organize the 3rd AMIS Academy, with 15 sessions on various subjects connected with our work and the technology we typically make use of. Visitors are welcome. For details about the sessions and to register for the Academy, go to: http://www.amis.nl/ The agenda for this session: Ronde […]