oracle数据库触发器（Trigger）增、删、改。

--添加数据

--insert
create or replace trigger jmcz_airport_in
after insert
on jmcz_airport
for each row
declare
-- local variables here
begin

insert into jmcz_airport select * from jmcz_airport@dblinktojm;

end jmcz_airport_in;

 

 

--修改数据
--update
create or replace trigger jmcz_airport_up
after update
on jmcz_airport
for each row
declare
-- local variables here
begin

delete from jmcz_airport@dblinktojm where airportid=:old.airportid;

insert into jmcz_airport select * from jmcz_airport@dblinktojm;

end jmcz_airport_up;

 

--删除数据
--delete
create or replace trigger jmcz_airport_del
after delete
on jmcz_airport
for each row
declare
-- local variables here
begin

delete from jmcz_airport@dblinktojm where AirportID=:old.AirportID;

end jmcz_airport_del;