PL/SQL has the IF statement for executing a statement conditionally. There are three forms of IF statements : IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF.
The simplest form of IF statement is shown below. It executes a sequence of statements only if the condition is true.
The second from of IF statement executes first sequence of statements if the condition is true otherwise executes the alternate sequence of statements.
As an alternate to case statement of Pascal, PL/SQL has IF-THEN-ELSIF statement. One of the mutually exclusive alternatives are executed depending on which of the given conditions is true.
