plsql if code example

Example 1: oracle else if

IF condition1 THEN
   {...statements to execute when condition1 is TRUE...}

ELSIF condition2 THEN
   {...statements to execute when condition1 is FALSE and condition2 is TRUE...}

ELSE
   {...statements to execute when both condition1 and condition2 are FALSE...}

END IF;

Example 2: plpgsql if statement

if condition then
  statements;
else
  alternative-statements;
END if;