Mega Code Archive

 

Categories / Oracle PLSQL / Sequence

 

A NOCYCLE sequence

SQL> -- A NOCYCLE sequence SQL> SQL> SQL> CREATE SEQUENCE StudentNumSeq   2    INCREMENT BY 50000   3    START WITH 50000   4    MAXVALUE   99999   5    NOCACHE   6    NOCYCLE; Sequence created. SQL> SQL> SQL> select studentNumSeq.nextVal from dual;    NEXTVAL ----------      50000 SQL> select studentNumSeq.nextVal from dual; select studentNumSeq.nextVal from dual                                   * ERROR at line 1: ORA-08004: sequence STUDENTNUMSEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated SQL> select studentNumSeq.nextVal from dual; select studentNumSeq.nextVal from dual * ERROR at line 1: ORA-08004: sequence STUDENTNUMSEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated SQL> SQL> SQL> drop sequence studentNumSeq; Sequence dropped. SQL> SQL>