摘要:
create or replace trigger TR_T_DWXXafter delete or update or insert ON T_DWXX for each row--单位 改变后 修改单位关系表declare curr_dwdh number:=0 ; PRAGMA AUTONOMOUS_TRANSACTION;--开启自治事物 i number:=0;BEGIN if inserting then select t.n_sjdw into curr_dwdh from t_dwxx t where t.n_dwdh=:new.N_SJDW; loop... 阅读全文