Comment on table or column
语法:
comment on table table_name is ‘hello table!’;
commnet on view view_name is ‘hello view!’;
comment on column [table|view].column is ‘hello column!’;
例子:
create table HX.HX_PO_CONTRACT_ITEMS (
item_number varchar2(100) not null,
item_THICKNESS number default null,
item_width number default null,
item_LENGTH number default null,
item_HEIGHT number default null,
item_CAIZHI varchar2(100) default null
);
comment on table HX.HX_PO_CONTRACT_ITEMS is ‘XXXX原材料物料编码材质规格对应表’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_NUMBER is ‘物料编码’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_THICKNESS is ‘厚度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_WIDTH is ‘宽度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_LENGTH is ‘长度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_HEIGHT is ‘高度’;
comment on column HX.HX_PO_CONTRACT_ITEMS.ITEM_CAIZHI is ‘材质’;

August 18th, 2008 at 2:34 pm
good example
August 28th, 2008 at 12:53 pm
看了你的文章,共振很厉害
August 28th, 2008 at 12:54 pm
我说的是生活和工作隔离带
Not this one