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

  • hooca

    2015-10-29 09:24:01
  • Oracle
  • 原创
对于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)

请使用浏览器的分享功能分享到微信等