说明:表源zginfo,被触发的表为jxhour,其共同的字段是zg_id,此触发器就是为了保证zg_id的数据的一致性create or replace trigger trigger_jxks
after delete or insert or update on zginfo
for each rowbeginif deleting then
delete from jxhour
where jxhour.zg_id=:old.zg_id;
end if; if inserting then
insert into jxhour(:old.zg_id) VALUES (:new.zg_id)
end if;if updating then
update jxhour
set jxhour.zg_id =:new.zg_id
end if;end;
insert into jxhour(zg_id) VALUES (:new.zg_id)