Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>