Query USER_SEQUENCES table to get the sequence info : USER_SEQUENCES « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_SEQUENCES

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>

           
       

Related examples in the same category