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 here:


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

Marco Gralike Written by: