当前位置: 代码迷 >> PowerDesigner >> -更新备份端remoteemp update remoteemp set sal=:new.sal where empno=:new.empno
  详细解决方案

-更新备份端remoteemp update remoteemp set sal=:new.sal where empno=:new.empno

热度:4835   发布时间:2013-02-26 00:00:00.0
--更新备份端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;
/
  相关解决方案