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

Материал из SQL эксперт
Перейти к: навигация, поиск

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>