Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: sequences
Automatic sequences not being dropped
One of the nice new things in 12c was the concept of identity columns. In terms of the functionality they provide (an automatic number default) it is really no different from anything we’ve had for years in the database via sequences, but native support…
Identity columns in 12c … just a sequence ?
This question came to me over Twitter, so I thought I’d whip out a quick post on it Yes, we do implement the IDENTITY column via a sequence. (Digression – I think this is a smart thing to do. After all, we’ve had…
Quick tip–identity columns
Lets say I’ve been reading about schema separation, and thus I am going to have a schema which owns all of my objects, which I’ll call APP_OWNER, which will have no connection privilege and a separate schema called APP_ADMIN which will take care of…
Let me START WITH sequences
It’s always cool that you can learn stuff every single day, even on the most simple of topics. This one came from an AskTom question. We define a sequence to start with 100, and then alter it to modify the INCREMENT BY. SQL> create…
Something new learned every day
One of the reasons I leapt at the chance to be on the AskTom team when we resurrected the site, was that it’s like free training. You get questions on topics you have not visited before, and you get new angles on things you…
DEFAULT SEQ.NEXTVAL in 12c
One of the cool things in 12c is that (finally after all these years) a sequence can be assigned as the default value for a column. Of course, some may say “big deal” – after all, it is trivial to create a simple trigger…
You dont need that sequence number
I’ve lost track of the number of times I see this sequence (no pun intended) of actions in code: SELECT my_sequence.nextval INTO :some_variable FROM dual; INSERT INTO my_table VALUES (:some_variable, ….); My question is always “Why?” What was it that made you so desperate…
