昨天发的那个触发器的意思大概是体系表变动后,其它几个表的全部数据都更新一次...这样开销太大了
这是公司前辈帮我修改的create or replace trigger T_YJZT
after update on bz_txb for each row
declare
-- local variables here
begin
update bz_jysxx set yjzt= :new.yjzt where :new.xh=bz_jysxx.xmbh;
update bz_gzdg set yjzt= :new.yjzt where :new.xh=bz_gzdg.xmbh;
update bz_zqyj set yjzt= :new.yjzt where :new.xh=bz_zqyj.xmbh;
update bz_ssgxx set yjzt= :new.yjzt where :new.xh=bz_ssgxx.xmbh;
update bz_bpgxx set yjzt= :new.yjzt where :new.xh=bz_bpgxx.xmbh;
end T_YJZT;
这东西很好用..很方便
