create or replace trigger trigger_name
after update on emp_salary
for each row
begin
insert into update_salary_log (....)
values(login_id,emp_id,emp_name,:old.emp_salary,:new.emp_salary,sysdate);
commit;
exception
when others then
rollback;
end;
after update on emp_salary
for each row
begin
insert into update_salary_log (....)
values(login_id,emp_id,emp_name,:old.emp_salary,:new.emp_salary,sysdate);
commit;
exception
when others then
rollback;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货