Mega Code Archive
Simple CASE statement with range
<![CDATA[
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 CASE TRUE
13 WHEN salary >= 10000 AND salary <=20000 THEN
14 give_bonus(employee_id, 1500);
15 WHEN salary > 20000 AND salary <= 40000 THEN
16 give_bonus(employee_id, 1000);
17 WHEN salary > 40000 THEN
18 give_bonus(employee_id, 500);
19 ELSE
20 give_bonus(employee_id, 0);
21 END CASE;
22 END;
23 /
PL/SQL procedure successfully completed.
SQL>
]]>