Oracle的V$檢視和DBA_檢視的參考提示

hooca發表於2015-10-29
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)

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22621861/viewspace-1817902/，如需轉載，請註明出處，否則將追究法律責任。

相關文章