oracle创建表+注释

前端之家收集整理的这篇文章主要介绍了oracle创建表+注释前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

建表的时候为了以后查询方便,也为了减少数据库文档的编写,建表最好加上表的注释和列的注释

建表语句:

CREATE table "TABLE_COUNT"

(
"TABLE_NAME" varchar2(40 char) not null enable,
"COUNT" varchar2(40 char) not null enable,
"DESCRIPTION" varchar2(40 char) not null enable,
"FLAG" varchar2(40 char) not null enable,
"CREATE_DATE" varchar2(40 char) not null enable,
PRIMARY KEY ("TABLE_NAME","CREATE_DATE")
);
comment on table "ZX_COUNT" is '每天产生的业务条数';
comment on column "ZX_COUNT"."TABLE_NAME" is '表名';
comment on column "ZX_COUNT"."COUNT" is '发生条数';
comment on column "ZX_COUNT"."DESCRIPTION" is '说明';
comment on column "ZX_COUNT"."FLAG" is '类型标记';
comment on column "ZX_COUNT"."CREATE_DATE" is '业务发生日期';

commit;;

查询语句:

select *from user_tab_comments where table_name='TABLE_COUNT';

select *from user_col_comments where table_name='TABLE_COUNT';

猜你在找的Oracle相关文章