René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Create sequence

create sequence sequence-name;
create sequence sequence-name increment by n;
create sequence sequence-name start with n;
create sequence sequence-name max value n;
create sequence sequence-name nomaxvalue;
create sequence sequence-name min value n;
create sequence sequence-name nominvalue;
create sequence sequence-name cycle;
create sequence sequence-name nocycle;
create sequence sequence-name cache n;
create sequence sequence-name nocache;
create sequence sequence-name order;
create sequence sequence-name noorder;
A sequence is a highly scalable, non-blocking ID generator.
Sequences can be used, for example, to generate primary keys. 
create sequence seq_foo_bar start with 1000 increment by 20;