SQL>
SQL> CREATE SEQUENCE StudentNumSeq
2 INCREMENT BY 1
3 START WITH 1100
4 MAXVALUE 99999
5 NOCACHE
6 NOCYCLE;
Sequence created.
SQL>
SQL> SELECT sequence_name, increment_by, cache_size, last_number
2 FROM USER_SEQUENCES
3 WHERE sequence_name ='STUDENTNUMSEQ';
SEQUENCE_NAME INCREMENT_BY CACHE_SIZE LAST_NUMBER
------------------------------ ------------ ---------- -----------
STUDENTNUMSEQ 1 0 1100
SQL>
SQL>
SQL> drop sequence StudentNumSeq;
Sequence dropped.
SQL>
SQL>