before_update_dept
before update of dname on dept for each row
begin
  if :old.dname = 'CORPORATE' and :old.deptno = 10 then
     :new.dname = 'CORPORATE';
  end if;
end;