CREATE OR REPLACE TRIGGER tese_cfqnew after UPDATE ON "SRRJ_copy1" FOR each ROW BEGIN EXECUTE IMMEDIATE ' merge into "ZB_copy1" a using (select * from "SRRJ_copy1" ) b on (a."合同编号" = b."合同编号" and a.回款金额 = b.sum(htje_srrj)) when not matched then update set a.回款金额 = b.sum(htje_srrj)'; end; b表更新后,提示缺失关键字，触发器执行过程出错，主键是合同编号 哪位高手能帮着看看吗oracle数据库 |
1min目标场景问卷
立即参与
