SQL>
SQL> -- Calculating overtime hours with IF.
SQL> set echo on
SQL> DECLARE
2 v_HoursWorked Number := 50 ;
3 v_OverTime Number := 0 ;
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 END IF;
9 END;
10 /
Hours overtime worked = 10
PL/SQL procedure successfully completed.