Assign init value to a number : Variable init « PL SQL « Oracle PL / SQL






Assign init value to a number


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>
           
       








Related examples in the same category

1.An initialization using the assignment operator (:=)
2.No initial value but Has a size
3.Declare variables to be used in the block