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;
The Song Jane [Doe, CEO] Likes
4 years ago
No comments:
Post a Comment