Oracle PL/SQL Tutorial/System Tables Data Dictionary/dict columns

Query dict_columns

SQL>
SQL> COLUMN column_name FORMAT A30
SQL> COLUMN comments FORMAT A40 WORD_WRAP
SQL>
SQL> SELECT column_name, comments
  2  FROM dict_columns
  3  WHERE table_name = "ALL_SEQUENCES";
SEQUENCE_OWNER                 Name of the owner of the sequence
SEQUENCE_NAME                  SEQUENCE name
MIN_VALUE                      Minimum value of the sequence
MAX_VALUE                      Maximum value of the sequence
INCREMENT_BY                   Value by which sequence is incremented
CYCLE_FLAG                     Does sequence wrap around on reaching
                               limit?
ORDER_FLAG                     Are sequence numbers generated in order?
CACHE_SIZE                     Number of sequence numbers to cache
LAST_NUMBER                    Last sequence number written to disk
9 rows selected.
SQL>
SQL>