Oracle PL/SQL/System Tables Views/ALL SEQUENCES
Getting information on sequences
SQL> set lin 300;
SQL>
SQL> --Getting information on sequences
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>
SQL>
SQL> select * from ALL_SEQUENCES;
SEQUENCE_OWNER SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE L
AST_NUMBER
------------------------------ ------------------------------ ------------------------ ------------------------ ------------------------ - - ------------------------ --------------
----------
SYS UGROUP_SEQUENCE .00 ######################## 1.00 N Y 10.00
1.00
SYS OBJECT_GRANT 1.00 ######################## 1.00 N Y 20.00
5421.00
SYS SYSTEM_GRANT 1.00 ######################## 1.00 N Y 20.00
690.00
SYS PROFNUM$ .00 ######################## 1.00 N N .00
1.00
SYS AUDSES$ 1.00 2000000000.00 1.00 Y N 20.00
82.00
SYS SNAPSHOT_ID$ 1.00 2147483647.00 1.00 N N 20.00
1.00
SYS SNAPSITE_ID$ 1.00 4294967295.00 1.00 N N 20.00
1.00
SYS JOBSEQ 1.00 999999999.00 1.00 Y N 20.00
21.00
SYS RGROUPSEQ 1.00 999999999.00 1.00 Y N 20.00
1.00
SYS ORA_TQ_BASE$ 1.00 4294967.00 1.00 Y N .00
7.00
SYS PARTITION_NAME$ 1.00 ######################## 1.00 N N 20.00
21.00
SEQUENCE_OWNER SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE L
AST_NUMBER
------------------------------ ------------------------------ ------------------------ ------------------------ ------------------------ - - ------------------------ --------------
----------
SYS CDC_SUBSCRIBE_SEQ$ 1.00 ######################## 1.00 N N 20.00
1.00
SYS CDC_RSID_SEQ$ 1.00 ######################## 1.00 N Y 10000.00
SQL>
SQL>