SQL>
SQL>
SQL> -- Using nested IF statements.
SQL> DECLARE
2 v_HoursWorked Number := 80 ;
3 v_OverTime Number := 0 ;
4 v_PayType char(1) := 'E';
5
6 BEGIN
7 IF v_HoursWorked > 40 THEN
8 IF v_PayType = 'H' THEN
9 v_OverTime := v_HoursWorked - 40;
10 DBMS_OUTPUT.PUT_LINE('Hours overtime worked = ' || v_OverTime);
11 ELSE
12 IF v_PayType = 'S' THEN
13 DBMS_OUTPUT.PUT_LINE('Employee is Salaried');
14 ELSE
15 DBMS_OUTPUT.PUT_LINE('Employee is Executive Management');
16 END IF;
17 END IF;
18 END IF;
19 END;
20 /
Employee is Executive Management
PL/SQL procedure successfully completed.
|