We killed sequence contention!
A few months back I gave a talk on the importance of good physical design if you need to meet
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