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: http://laurentschneider.com/
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
