From my long time experience with Oracle, I noticed that a lot of people have problems with Outer Joins. Especially if the Outer Join also contains an additional restriction on the outer join table.
Because it’s a PL/SQL development tool focused on PL/SQL development. Most of the other tools like TOAD or SQL Developer which I also used in the past, have great DBA/query functionality, but suck from a “state of the art” programming point of view.
A few days ago I came across an interesting posting on the AMIS blog about an XML(DB) presentation at the OOP 2007 conference.
The presentation done by Ken Atkins is also available online and is really worth reading it. It gives a comprehensive overview (with lot of examples) of the built-in XML processing features of the Oracle database.
Just read a nice SQL puzzle on the AMIS blog called Writing a pure SQL based String Tokenizer and because Lucas wrote
Please share with me your thoughts on this – but I will share my attempt with you anyway
That’s why I thought I have to train my brain a little bit with a nice SQL statement… and here is my result using CONNECT BY instead of CUBE.
Just got a newsletter from Oracle with an article that they are looking for Beta tester for the upcoming Oracle 11g Database release.
Check out Oracle Database 11g Beta Program Underway.