Oracle的V$视图和DBA_视图的参考提示

对于V$视图，包括GV$，参考V$FIXED_TABLE

点击(此处)折叠或打开

1. SQL> desc V$FIXED_TABLE
   
2.  Name                                      Null?      Type
   
3.  ----------------------------------------- -------- ----------------------------
   
4.  NAME                                                  VARCHAR2(30)
   
5.  OBJECT_ID                                             NUMBER
   
6.  TYPE                                                  VARCHAR2(5)
   
7.  TABLE_NUM                                             NUMBER

对于DBA视图，包括USER和ALL，参考dba_tab_comments 

点击(此处)折叠或打开

1. SQL> desc dba_tab_comments
   
2.  Name                                      Null?      Type
   
3.  ----------------------------------------- -------- ----------------------------
   
4.  OWNER                                     NOT NULL     VARCHAR2(30)
   
5.  TABLE_NAME                                NOT NULL     VARCHAR2(30)
   
6.  TABLE_TYPE                                             VARCHAR2(11)
   
7.  COMMENTS                                               VARCHAR2(4000)

另有dba_col_comments，可查询列的说明。

点击(此处)折叠或打开

1. SQL> desc dba_col_comments
   
2.  Name                                      Null?      Type
   
3.  ----------------------------------------- -------- ----------------------------
   
4.  OWNER                                     NOT NULL     VARCHAR2(30)
   
5.  TABLE_NAME                                NOT NULL     VARCHAR2(30)
   
6.  COLUMN_NAME                               NOT NULL     VARCHAR2(30)
   
7.  COMMENTS                                               VARCHAR2(4000)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22621861/viewspace-1817902/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22621861/viewspace-1817902/