Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Get information on all the sequences you have access to using all_sequences

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;