建立触发器
create or replace trigger hr.new_emp_dept1
instead of update on hr.emp_details
for each row
begin
UPDATE hr.new_emps
set employee_id=:NEW.employee_id,
salary=:NEW.salary
where employee_id=:OLD.employee_id;
UPDATE hr.new_depts
set tot_dept_sal=tot_dept_sal+(:NEW.salary-:OLD.salary)
where department_id=:OLD.department_id;
END; 然后执行update hr.emp_details
set employee_id=employee_id+1,
salary=salary*1.2
where employee_id>'200';
要求 分析salary和id属性,哪个先变动……
create or replace trigger hr.new_emp_dept1
instead of update on hr.emp_details
for each row
begin
UPDATE hr.new_emps
set employee_id=:NEW.employee_id,
salary=:NEW.salary
where employee_id=:OLD.employee_id;
UPDATE hr.new_depts
set tot_dept_sal=tot_dept_sal+(:NEW.salary-:OLD.salary)
where department_id=:OLD.department_id;
END; 然后执行update hr.emp_details
set employee_id=employee_id+1,
salary=salary*1.2
where employee_id>'200';
要求 分析salary和id属性,哪个先变动……
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货