About Oracle

Tuesday March 30, the Dutch Oracle usergroup OGh organizes one entire day dedicated to APEX. I'm a little biased, as I helped organizing...

To implement entity rules and inter-entity rules, one of the options is to use an on commit-time fast refreshable materialized view with a c...

At work I am building an interface using SQL object types and SQL collection types. I noticed a difference between using the COLLECT aggrega...

This was the title of a thread on OTN's SQL and PL/SQL Forum. Centinul posted an interesting puzzle to be solved by either SQL or PL/SQL...

In 2009 I have presented "Alles Over Groeperen" twice in the Netherlands and the English version "All About Grouping" al...

In version 11.1.0.6, Oracle introduced flashback data archives under the marketing term Total Recall. Previously you could only flashback yo...

A colleague of mine sent me this link , and wanted me to have a look at point 5: Choose sys_guid() instead of sequences for populating meani...