plsqlIF-THEN-ELSE Statement


Syntax

  • IF [condition 1] THEN

  • [statements to execute when condition 1 is TRUE];

  • ELSIF [condition 2] THEN

  • [statements to execute when condition 2 is TRUE];

  • ELSE

  • [statements to execute when both condition 1 & condition 2 are FALSE];

  • END IF;