Inside Oracle APEX by Patrick Wolf

Oracle Database 11g will be launched on July 11

Just read on Edie Awad’s blog, that the Oracle Database 11g is going to be launched on July 11 with an event in New York City.

The mystery of Outer Joins

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.

New version of Migration Workbench available

Just read on

What is your favorite PL/SQL development environment?

Mine is PL/SQL Developer from allroundautomations. Why? 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.

Creating a Gantt-chart in SQL

A few days ago Lucas Jellema from AMIS posted a real nice SQL statement to generate a character based Gantt-chart. I think it’s a good demonstration of the possibilities and the power of SQL. Have a look!

Sending a SMS to a mobile phone

Today I read an article on Grant Rolands blog about sending a SMS from Oracle Forms through a Web-Service. I thought it would be nice to have the same in APEX and PL/SQL, too. For example if you have a system failure or get a new order in your shop…

XML processing in the database

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 [...]

SQL based String Tokenizer – another approach using CONNECT BY

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 [...]

Setting SYSDATE to a fixed value

Oracle is looking for 11g Beta tester

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