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;