我给oracle视图的列加了注释，如下
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.MTRL_DICT_ID is ‘物资字典ID’;
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.ATTR_ID is ‘物资属性ID’;
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.MTRL_CODE is ‘物资代码’;
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.MTRL_NAME is ‘物资名称’;
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.MTRL_SPEC is ‘规格’;
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.MTRL_MODEL is ‘物资型号’;
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.MTRL_BRAND is ‘物资品牌’;
comment on column HRP_1001.V_MTRL_DICT_LIST_TOTAL.MTRL_STATUS is ‘停用标志’;
但是却不知道怎么查看这些列的注释，我用user_col_comments 却查看不到，不知道应该怎么看：
SQL> select * from user_col_comments where TABLE_NAME=‘V_MTRL_DICT_LIST_TOTAL_QY’;
TABLE_NAME COLUMN_NAME COMMENTS
V_MTRL_DICT_LIST_TOTAL_QY MTRL_DICT_ID
V_MTRL_DICT_LIST_TOTAL_QY ATTR_ID
V_MTRL_DICT_LIST_TOTAL_QY ATTR_NAME
V_MTRL_DICT_LIST_TOTAL_QY MTRL_CODE
V_MTRL_DICT_LIST_TOTAL_QY MTRL_NAME
V_MTRL_DICT_LIST_TOTAL_QY MTRL_SPEC
V_MTRL_DICT_LIST_TOTAL_QY MTRL_MODEL
V_MTRL_DICT_LIST_TOTAL_QY MTRL_BRAND
V_MTRL_DICT_LIST_TOTAL_QY UNITS
V_MTRL_DICT_LIST_TOTAL_QY UNITS_NAME
V_MTRL_DICT_LIST_TOTAL_QY MTRL_STATUS
DBA_COL_COMMENTS displays comments on the columns of all tables and views in the database.
ALL_COL_COMMENTS displays comments on the columns of the tables and views accessible to the current user.
USER_COL_COMMENTS displays comments on the columns of the tables and views owned by the current user. This view does not display the OWNER column.
评论
有用 0DBA_COL_COMMENTS 、ALL_COL_COMMENTS 、USER_COL_COMMENTS
这三个都查不到视图 列的注释。
那看来oracle没办法查看视图的注释，加注释没用
评论 有用 0我自己测试结果，可以看到注释呀。
HR@messay > create view test_view as select * from user_objects;
HR@messay > selecT table_name,column_name,comments from user_col_comments where table_name=‘TEST_VIEW’;
TABLE_NAME COLUMN_NAME COMMENTS
TEST_VIEW OBJECT_NAME
TEST_VIEW SUBOBJECT_NAME
TEST_VIEW OBJECT_ID
TEST_VIEW DATA_OBJECT_ID
TEST_VIEW OBJECT_TYPE
TEST_VIEW CREATED
TEST_VIEW LAST_DDL_TIME
TEST_VIEW TIMESTAMP
TEST_VIEW STATUS
TEST_VIEW TEMPORARY
TEST_VIEW GENERATED
TEST_VIEW SECONDARY
TEST_VIEW NAMESPACE
TEST_VIEW EDITION_NAME
HR@messay > comment on column hr.test_view.EDITION_NAME is ‘测试测试测试’;
Comment created.
HR@messay > selecT table_name,column_name,comments from user_col_comments where table_name=‘TEST_VIEW’;
TABLE_NAME COLUMN_NAME COMMENTS
TEST_VIEW OBJECT_NAME
TEST_VIEW SUBOBJECT_NAME
TEST_VIEW OBJECT_ID
TEST_VIEW DATA_OBJECT_ID
TEST_VIEW OBJECT_TYPE
TEST_VIEW CREATED
TEST_VIEW LAST_DDL_TIME
TEST_VIEW TIMESTAMP
TEST_VIEW STATUS
TEST_VIEW TEMPORARY
TEST_VIEW GENERATED
TEST_VIEW SECONDARY
TEST_VIEW NAMESPACE
TEST_VIEW EDITION_NAME 测试测试测试
评论 有用 0
