日期:2014-05-16 浏览次数:20390 次
create table t_temp ( old_sal number(7,2), new_sal number(7,2), who varchar2(20), log timestamp ); create or replace trigger update_emp_sal before update of sal on emp for each row begin insert into t_temp values(:old.sal,:new.sal,user,sysdate); end; /