oracle添加注释失败,oracle 添加注释

表的注释：

yang@rac1>desc user_col_comments

Name                       Null?    Type

-------------------------- -------- ------------

TABLE_NAME                 NOT NULL VARCHAR2(30)

COLUMN_NAME                NOT NULL VARCHAR2(30)

COMMENTS                            VARCHAR2(4000)

yang@rac1>comment on table tchar is ' 这是一个测试表';

Comment created.

yang@rac1>select table_name ,comments from user_tab_comments;

TABLE_NAME                     COMMENTS

------------------------------ -----------------------

TCHAR                           这是一个测试表

表中字段的注释：

yang@rac1>desc user_col_comments

Name                      Null?    Type

------------------------ -------- ----------------------------

TABLE_NAME               NOT NULL VARCHAR2(30)

COLUMN_NAME              NOT NULL VARCHAR2(30)

COMMENTS                          VARCHAR2(4000)

yang@rac1>comment on column tchar.val is ' 测试 来自客户 ';

Comment created.

yang@rac1>col comments for a45

yang@rac1>select comments from user_col_comments where table_name='TCHAR' and column_name='VAL';

COMMENTS

---------------------------------------------

测试 来自客户

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