摘要: 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... 阅读全文
posted @ 2013-09-17 20:51 mingyue1818 阅读(259) 评论(0) 推荐(0) 编辑