About Oracle

Ok, I may be the last person seeing this, but I thought this is just too funny not to share it. I found a way to get rid of those annoying s...

Today was OGh's APEX day. I saw 5 good presentations, in which I was not bored by Powerpoint once. I probably missed a few other good on...

To insert the data from an XML document into multiple relational tables, you can use PL/SQL, loop statements and the extract function. But I...

PL/SQL got me fooled today. My assignment was to build a new procedure that gets invoked together with an existing procedure. After I had bu...

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