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>