/* ================================================================================ 档案代号:zak_file 档案名称:定义设定查询的sql 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zak_file ( zak01 varchar2(80) NOT NULL, /*查询单ID */ zak02 varchar2(2000), /*SQL命令 */ zak03 varchar2(2000), /*table 列表 */ zak04 varchar2(2000), /*Field 列表 */ zak05 varchar2(2000), /*where 条件 */ zak06 varchar2(1), /*SQL是否由Wizard产生 */ zak07 varchar2(1) NOT NULL, /*客制码 */ zak08 varchar2(255) /*No Use */ ); create unique index zak_pk on zak_file (zak01,zak07); alter table zak_file add constraint zak_pk primary key (zak01,zak07) enable validate; grant select on zak_file to public; grant index on zak_file to public; grant update on zak_file to public; grant delete on zak_file to public; grant insert on zak_file to public; |