About Oracle

Version 11g release 2 introduced recursive subquery factoring or the recursive with clause. This is an extension to the SQL syntax with whic...

This year, the Dutch Oracle usergroup OGh has started to offer a set of 4 presentations, called the ACE Cases. Each presentation is given by...

In version 11.2.0.1, Oracle introduced three new hints: IGNORE_ROW_ON_DUPKEY_INDEX , CHANGE_DUPKEY_ERROR_INDEX and RETRY_ON_ROW_CHANGE . Th...

On Thursday 10AM I gave a presentation at the Unconference called "All About Grouping". I really need to think more about titles o...

Tuesday was a very rainy day. I decided to take the shuttle bus to the Moscone and was therefore a little late for the first session. The se...

This year I'm visiting Oracle OpenWorld for the second time. Everything is now familiar, except for two differences. First one is the lo...

Remember the opening statement of the MV error series? It was "Never put more than one error condition into one error message". Tw...