/* ================================================================================ 档案代号:oab_file 档案名称:销售分类档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oab_file ( oab01 varchar2(10) NOT NULL, /*销售分类码 */ oab02 varchar2(80) /*分类名称 */ ); create unique index oab_pk on oab_file (oab01); alter table oab_file add constraint oab_pk primary key (oab01) enable validate; grant select on oab_file to public; grant index on oab_file to public; grant update on oab_file to public; grant delete on oab_file to public; grant insert on oab_file to public; |