/* ================================================================================ 档案代号:nph_file 档案名称:银行假日设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nph_file ( nph01 date NOT NULL, /*假日日期 */ nph02 varchar2(80) /*假日名称 */ ); create unique index nph_pk on nph_file (nph01); alter table nph_file add constraint nph_pk primary key (nph01) enable validate; grant select on nph_file to public; grant index on nph_file to public; grant update on nph_file to public; grant delete on nph_file to public; grant insert on nph_file to public; |