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.