Oracle -- 添加表和列的注释

1. 表的注释

comment on table t_A is '表的注释';

2. 列的注释

comment on column t_A.id is '编号';comment on column t_A.name is '姓名';comment on column t_A.birthday is '出生日期';comment on column t_A.sal is '薪水';

3. 查看表的注释（注意值全部是大写）

select * from user_tab_comments where table_name = 'T_A';

4. 查看列的注释（注意值全部是大写）

select * from user_col_comments where table_name = 'T_A';