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
Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance.He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).
0 0 %
0 0 %
0 0 %
0 0 %
0 0 %
0 0 %
Fri May 4 , 2007
Tuesday 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 […]
4 thoughts on “Brilliant use of XML in the relational database”
FYI, I’ve updated the solution on the SQL Snippets page that Leon and Marco refer to above (http://www.sqlsnippets.com/en/topic-11785.html). The old solution used some convoluted REGEXP_REPLACE logic. The new one uses a more elegant approach involving EXTRACT and LTRIM that OTN user “michaels” suggested at http://forums.oracle.com/forums/thread.jspa?threadID=502349&start=0&tstart=0.
Great site by the way. Lot’s of interesting idea’s.
Thanks for the tip, I found it (http://www.sqlsnippets.com/en/topic-11785.html). Laurent spoke about the possibility during Oracle Open World 2006. It’s great to see a working example.
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.
Comments are closed.