/* ================================================================================ 档案代号:too_file 档案名称:省别编号维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table too_file ( too01 varchar2(10) NOT NULL, /*省别代号 */ too02 varchar2(80), /*省别名称 */ too03 varchar2(10), /*区域代号 */ tooacti varchar2(1) /*有效否 */ ); create unique index too_pk on too_file (too01); alter table too_file add constraint too_pk primary key (too01) enable validate; grant select on too_file to public; grant index on too_file to public; grant update on too_file to public; grant delete on too_file to public; grant insert on too_file to public; |