Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query USER_SEQUENCES table to get the sequence info

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>