Oracle Sequences
- by jkrebsbach
Reminder to myself -
SQL Server has nice index columns directly tied to their tables.
Oracle has sequences that are islands to themselves.
select seq_name.currval from dual;
select seq_name.nextval from dual;
currval - return current number at top of sequence
nextval - increment sequence by 1, return new number
therefore - to create…