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>