ALL_COL_COMMENTS
2011. 12. 22. 10:24ㆍOracle/Oracle Dictionary
반응형
http://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1036.htm
ALL_COL_COMMENTS
ALL_COL_COMMENTS displays comments on the columns of the tables and views accessible to the current user.
DBA_COL_COMMENTSdisplays comments on the columns of all tables and views in the database.USER_COL_COMMENTSdisplays comments on the columns of the tables and views owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column |
COMMENTS |
VARCHAR2(4000) |
Comment on the column |
반응형
'Oracle > Oracle Dictionary' 카테고리의 다른 글
| v$rollstat (0) | 2011.04.15 |
|---|---|
| v$session (0) | 2011.04.14 |