Conditional Statements in PL/SQL
https://www.computersprofessor.com/2017/08/conditional-statements-in-plsql.html?m=0
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++.
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;