部门进行填报人员薪资时 对部门人员进行全量Excel导入,前提是,将旧数据删除(条件:相同版本号和部门id)后再进行导入,用触发器进行删除操作删除时用到:版本号 ,部门id,年度;进行条件删除数据库:oracle目前写的语句:CREATE TRIGGER FR_ERP_RYYS before INSERT ON TC_GGH_FILEFOR EACH ROWBEGIN DELETE TC_GGH_FILE WHERE tc_ggh38 in(:now.TC_GGH38) AND tc_ggh01 in(:now.TC_GGH01) AND tc_ggh35 in (:now.TC_GGH01);END;2或者CREATE TRIGGER FR_ERP_RYYS before INSERT ON TC_GGH_FILEFOR EACH ROWBEGIN DELETE TC_GGH_FILE WHERE :now.TC_GGH38=tc_ggh38 AND :now.TC_GGH01=tc_ggh01 AND :now.TC_GGH35=tc_ggh35;END;上面两种都不对,感觉是错在条件删除那里,求大神指点