Learning is not a spectator sport

MERGE and IOT’s ….. unhappy bedfellows

Anyone who has used Oracle for a while will be familiar with the Parent/Child locking “issue” when it comes to

This was going to the be the immediate follow up to my previous post, but 12.1.0.2 came out and I

One of my favourite security “tricks” used to be the following: SQL> [create|alter] user MY_USER identified by values ‘impossible’; Looks

A common criticism of PLSQL is that the “original” array datatype, now called associative arrays are perfect for passing stuff

Sadly there seems to be no concept of the Hakan factor for an IOT. I have an application which merges

We have a fairly common query process, where we run a MERGE command to compare a remote table to a

I played a lot of volleyball in a bygone life 🙂 and subsequently ruined my knees to the extent that

We did a “real” upgrade to 12c this weekend, where “real” means a production system, as opposed to my laptop,

In the previous post, I pontificated about triggers that “lock you in” to having them fire, which can create dramas

Some people hate triggers, some people love triggers… I am not that opinionated on them in either direction, but one