--更新备份端remoteemp update remoteemp set sal=:new.sal where empno=:new.empno;
数据的备份和同步
在主数据库上,给员工涨工资,新的工资拷贝到备份端
create or replace trigger syncsal
after update
on emp
begin
--更新备份端remoteemp
update remoteemp set sal=:new.sal where empno=:new.empno;
end;
/