1.
-- 创建一个备份表
create table emp_0707 as select * from employees;
select * from employees;
select * from emp_0707;
2.
--创建一个procedure来实现
create or replace procedure add_sal_0707
is
cursor empcur is
select * from emp_0707;
v_temp number(4,2);
begin
for c in empcur loop
if c.hire_date<= to_date('1989-12-31','yyyy-mm-dd') then
v_temp:=0.2;
elsif c.hire_date<= to_date('1995-12-31','yyyy-mm-dd') then
v_temp:=0.15;
else v_temp:=0.1;
end if;
update emp_0707 set salary=salary*(1+v_temp)
where employee_id=c.employee_id;
end loop;
commit;
end;
3.
--运行
begin
add_sal_0707 ;
end;
4.表的内容
employees:
emp_0707: