The IF...THEN...ELSE Statement : IF « PL SQL Statements « Oracle PL/SQL Tutorial

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

The IF...THEN...ELSE statement allows you to process a series of statements under ELSE if the condition is false.

The Syntax for the IF...THEN...ELSE Statement

IF  <some_condition_evaluates_to_true>
THEN
    <perform_statements_condition_true>
ELSE
    <perform_statements_condition_false>
END IF;

some_condition_evaluates_to_true, tests a BOOLEAN condition that you provide.

If true, the second parameter, perform_statements_condition_true, executes.

If the condition is false, the parameter perform_statements_condition_false executes.

SQL>
SQL> set echo on
SQL>
SQL> DECLARE
  2    v_a Number := 50 ;
  3    v_b Number;
  4  BEGIN
  5    IF v_a > 40 THEN
  6      v_b := v_a - 40;
  7         DBMS_OUTPUT.PUT_LINE('Hours b worked = ' || v_b);
  8       ELSE
  9            v_b := 0;
 10    END IF;
 11  END;
 12  /
Hours b worked = 10

PL/SQL procedure successfully completed.

SQL>