查看某个视图某列的含义,不用百度
SQL> set line 80
SQL> desc dict_columns
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> set line 200
SQL> select * from dict_columns where table_name='DBA_TABLES' and column_name='CACHE';
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ --------------------------------------------------
DBA_TABLES CACHE Whether the table is to be cached in the buffer ca
che
查询某个表的所有列的含义:
SQL> select * from dict_columns where table_name ='ALL_SNAPSHOTS';
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------
ALL_SNAPSHOTS OWNER Owner of the snapshot
ALL_SNAPSHOTS NAME The view used by users and applications for viewing the snapshot
ALL_SNAPSHOTS TABLE_NAME Table the snapshot is stored in -- has an extra column for the master rowid
ALL_SNAPSHOTS MASTER_VIEW View of the master table, owned by the snapshot owner, used for refreshes
ALL_SNAPSHOTS MASTER_OWNER Owner of the master table
ALL_SNAPSHOTS MASTER Name of the master table that this snapshot is a copy of
ALL_SNAPSHOTS MASTER_LINK Database link name to the master site
ALL_SNAPSHOTS CAN_USE_LOG If NO, this snapshot is complex and will never use a log
ALL_SNAPSHOTS UPDATABLE If NO, the snapshot is read only. Look up REPLICATION
ALL_SNAPSHOTS REFRESH_METHOD The values used to drive a fast refresh of the snapshot
ALL_SNAPSHOTS LAST_REFRESH SYSDATE from the master site at the time of the last refresh
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------
ALL_SNAPSHOTS ERROR The error returned last time an automatic refresh was attempted
ALL_SNAPSHOTS FR_OPERATIONS
ALL_SNAPSHOTS CR_OPERATIONS
ALL_SNAPSHOTS TYPE The type of refresh (complete,fast,force) for all automatic refreshes
ALL_SNAPSHOTS NEXT The date function used to compute next refresh dates
ALL_SNAPSHOTS START_WITH The date function used to compute next refresh dates
ALL_SNAPSHOTS REFRESH_GROUP All snapshots in a given refresh group get refreshed in the same transaction
ALL_SNAPSHOTS UPDATE_TRIG The name of the trigger which fills the UPDATE_LOG
ALL_SNAPSHOTS UPDATE_LOG The table which logs changes made to an updatable snapshots
ALL_SNAPSHOTS QUERY The original query that this snapshot is an instantiation of
ALL_SNAPSHOTS MASTER_ROLLBACK_SEG Rollback segment to use at the master site
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------
ALL_SNAPSHOTS STATUS The status of the contents of the snapshot
ALL_SNAPSHOTS REFRESH_MODE This indicates how and when the snapshot will be refreshed
ALL_SNAPSHOTS PREBUILT If YES, this snapshot uses a prebuilt table as the base table
25 rows selected.