Oracle PL/SQL/Sequence/Sequence Start

Set sequence start value

   <source lang="sql">

SQL> SQL> 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> SQL> SQL> SQL> DROP SEQUENCE StudentNumSeq; Sequence dropped. SQL> SQL> SQL>

      </source>