Mega Code Archive

 

Categories / Oracle PLSQL / Sequence

 

Get Sequence next value

SQL> SQL> SQL> CREATE SEQUENCE StudentNumSeq   2    INCREMENT BY 1   3    START WITH 1100   4    MAXVALUE 99999   5    NOCACHE   6    NOCYCLE; Sequence created. SQL> SQL> commit; Commit complete. SQL> SQL> select StudentNumSeq.NEXTVAL from DUAL;                  NEXTVAL ------------------------                  1100.00 SQL> SQL> drop sequence StudentNumSeq; Sequence dropped. SQL> SQL> commit; Commit complete. SQL> SQL>