create or replace trigger tg_E_CONTACT before instead of update or instead of insert or instead of delete on E_CONTACT for each row begin if inserting then insert into E_CONTACT@gaac.world values (:new.TELEPHONE, :new.EMPLOYEEID, :new.STATUS); else if updating then update E_CONTACT@gaac.world s set s.TELEPHONE = :new.TELEPHONE, s.EMPLOYEEID = :new.EMPLOYEEID, s.STATUS = :new.STATUS where s.employeeid = :old.employeeid; else if deleting then delete from E_CONTACT@gaac.world s where s.employeeid = :old.employeeid; end if; end if; end if; end;