/* ================================================================================ 档案代号:oaf_file 档案名称:常用说明单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oaf_file ( oaf01 varchar2(4) NOT NULL, /*说明代码 */ oaf02 number(5) NOT NULL, /*行序 */ oaf03 varchar2(255) /*说明 */ ); create unique index oaf_pk on oaf_file (oaf01,oaf02); alter table oaf_file add constraint oaf_pk primary key (oaf01,oaf02) enable validate; grant select on oaf_file to public; grant index on oaf_file to public; grant update on oaf_file to public; grant delete on oaf_file to public; grant insert on oaf_file to public; |