|
SQL> DECLARE
2 salary NUMBER := 20000;
3 employee_id NUMBER := 36325;
4
5 PROCEDURE give_bonus (emp_id IN NUMBER, bonus_amt IN NUMBER) IS
6 BEGIN
7 DBMS_OUTPUT.PUT_LINE(emp_id);
8 DBMS_OUTPUT.PUT_LINE(bonus_amt);
9 END;
10
11 BEGIN
12 IF salary BETWEEN 10000 AND 20000
13 THEN
14 give_bonus(employee_id, 1500);
15 ELSIF salary BETWEEN 20000 AND 40000
16 THEN
17 give_bonus(employee_id, 1000);
18 ELSIF salary > 40000
19 THEN
20 give_bonus(employee_id, 500);
21 ELSE
22 give_bonus(employee_id, 0);
23 END IF;
24 END;
25 /
PL/SQL procedure successfully completed.
SQL>
|