Get information on all the sequences you have access to using all_sequences. : all_sequences « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL> desc all_sequences;
 Name             Null?    Type
 -----------------
 SEQUENCE_OWNER   NOT NULL VARCHAR2(30)
 SEQUENCE_NAME    NOT NULL VARCHAR2(30)
 MIN_VALUE                 NUMBER
 MAX_VALUE                 NUMBER
 INCREMENT_BY     NOT NULL NUMBER
 CYCLE_FLAG                VARCHAR2(1)
 ORDER_FLAG                VARCHAR2(1)
 CACHE_SIZE       NOT NULL NUMBER
 LAST_NUMBER      NOT NULL NUMBER

SQL>                                                                                                                                                                   Null?    Type
SQL> --select * from all_sequences;








30.12.all_sequences
30.12.1.Get information on all the sequences you have access to using all_sequences.
30.12.2.Using a Sequence