IF THEN and END IF : IF « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. IF

IF THEN and END IF

    

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.








Related examples in the same category

1.IF...ELSIF...ELSE... END IF
2.The IF statement contains more than one statement per condition.
3.Adding ELSE to the IF block
4.IF, ELSIF ELSE and END IF
5.Using nested IF statements
6.Using IF...ELSIF to determine a grade
7.if then else
8.A conditional statement
9.Check number value in if statement
10.Exit a loop with condition
11.If ladder
12.Compare three variables with if statement
13.If count() is 0, insert data
14.If condition meets, throw exception
15.Nested if statement
16.If...then...Else
17.Using a Boolean variable instead of the comparison operation
18.An if-then-elsif-then-else statement where the first two comparisons are true and the third false
19.Create a function and call it in an if statement