System Tables Views Oracle PLSQL

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>