PROCEDURE: SCOTT.GIVE_RAISE

Source

1 procedure       give_raise (
2     p_deptno in number,
3     p_raise_percent in number )
4 as
5 begin
6    update emp set sal = sal + (sal * p_raise_percent * .01)
7    where deptno = p_deptno;
8 
9    commit;
10 end give_raise;