sequences – Learning is not a spectator sport

We killed sequence contention!

A few months back I gave a talk on the importance of good physical design if you need to meet

When sequences won’t do In an Oracle database if someone comes to you and says “I need to generate unique

Fellow Perth techie Scott Wesley sent me this interesting puzzle recently. He was using the long awaited feature of being

One of the nice new things in 12c was the concept of identity columns. In terms of the functionality they

This question came to me over Twitter, so I thought I’d whip out a quick post on it Yes,

Lets say I’ve been reading about schema separation, and thus I am going to have a schema which owns all

It’s always cool that you can learn stuff every single day, even on the most simple of topics. This one

One of the reasons I leapt at the chance to be on the AskTom team when we resurrected the site,

One of the cool things in 12c is that (finally after all these years) a sequence can be assigned as

I’ve lost track of the number of times I see this sequence (no pun intended) of actions in code: SELECT