Conditional Statements in PL/SQL

As the name implies, PL/SQL supports programming language features like conditional statements, iterative statements.

The programming constructs are similar to how you use in programming languages like Java and C++. In this section I will provide you syntax of how to use conditional statements in PL/SQL programming.

IF THEN ELSE STATEMENT

1)

IF condition

THEN

 statement 1;

ELSE

 statement 2;

END IF;



2)

IF condition 1

THEN

 statement 1;

 statement 2;

ELSIF condtion2 THEN

 statement 3;

ELSE

 statement 4;

END IF



3)

IF condition 1

THEN

 statement 1;

 statement 2;

ELSIF condtion2 THEN

 statement 3;

ELSE

 statement 4;

END IF;



4)

IF condition1 THEN

ELSE

 IF condition2 THEN

 statement1;

 END IF;

ELSIF condition3 THEN

  statement2;

END IF;