create or replace trigger trigger_test after insert or update or delete on A
for each row
begin
delete A@DBLink where name = :old.name;
if inserting or updating then
insert into A@DBLink values(:new.name,:new.fd2,...);
end if;
exception
when others then
null;
end;
for each row
begin
delete A@DBLink where name = :old.name;
if inserting or updating then
insert into A@DBLink values(:new.name,:new.fd2,...);
end if;
exception
when others then
null;
end;
update语句只能这样写。
建立别名!