PL/SQL Conditional Statements

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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.

Conditional Statements in PL/SQL

 

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;