Query dict_columns : dict_columns « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. 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>