SQL>
SQL> -- Adding ELSE to the IF block.
SQL> set echo on
SQL> DECLARE
2 v_HoursWorked Number := 50 ;
3 v_OverTime Number ;
4 BEGIN
5 IF v_HoursWorked > 40 THEN
6 v_OverTime := v_HoursWorked - 40;
7 DBMS_OUTPUT.PUT_LINE('Hours overtime worked = ' || v_OverTime);
8 ELSE
9 v_OverTime := 0;
10 END IF;
11 END;
12 /
Hours overtime worked = 10
PL/SQL procedure successfully completed.
SQL>
|