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>