DBA Data[Home] [Help]

SCOTT.GIVE_RAISE dependencies on EMP

Line 6: update emp set sal = sal + (sal * p_raise_percent * .01)

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;