Oracle PL/SQL Tutorial/System Tables Data Dictionary/dict columns
Query dict_columns
<source lang="sql">
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></source>