Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>