CREATE SEQUENCE sequence_name
    MINVALUE VALUE
    MAXVALUE VALUE
    START WITH VALUE
    INCREMENT BY VALUE
    CACHE VALUE;
 
-- If you omit the MAXVALUE option, your sequence will 
-- automatically default to:
 
    MAXVALUE 99999999999999999999999999
 
 
-- create sequence demo:
 
CREATE SEQUENCE supplier_seq
     MINVALUE 1
     MAXVALUE 999999999999999999999999999
     START WITH 1
     INCREMENT BY 1
     CACHE 20;
 
Sequence created.
 
 
 SELECT supplier_seq.NEXTVAL FROM dual;
 
   NEXTVAL
----------
         1
 
 SELECT supplier_seq.NEXTVAL FROM dual;
 
   NEXTVAL
----------
         2
 
 SELECT supplier_seq.NEXTVAL FROM dual;
 
   NEXTVAL
----------
         3
 
 SELECT supplier_seq.NEXTVAL FROM dual;
 
   NEXTVAL
----------
         4
 
 
DROP sequence supplier_seq;
 
Sequence dropped.