Oracle PL/SQL/System Tables Views/USER SEQUENCES
Query user_sequences table
<source lang="sql">
SQL> SQL> SELECT sequence_name, increment_by,
2 DECODE(cycle_flag,"y"," cycle","n", "nocycle", "nocycle") 3 cycle_flag, 4 DECODE(order_flag,"y"," order","n", "noorder", "noorder") 5 order_flag, 6 max_value, min_value, cache_size, last_number 7 FROM user_sequences 8 where rownum < 50 9 ORDER BY sequence_name;
no rows selected
</source>
Query USER_SEQUENCES table to get the sequence info
<source lang="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> 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>
</source>