在Oracle中编写编写一个存储过程upsal接受一个员工号 – 网络|

CREATE OR REPLACE PROCEDURE upsal(emp_id integer) IS

BEGIN

for rc in (select duty, workplace from emp where empid = emp_id) loop

if rc.duty = ‘MANAGER’ and workplace = ‘DALLAS’ then

update emp set salary = salary * 1.15;

end if;

if rc.duty = ‘CLERK’ and workplace = ‘NEW YORK’ then

update emp set salary = salary * 0.95;

end if;

end loop;

END;