Control structures do one of two things: they check a logical condition to branch program execution, or they iterate over a condition until it is met or they are instructed to exit. The section “Conditional Structures” covers if, elsif, else, and case statements, and the section “Iterative Structures” covers looping with for and while structures.
Conditional statements check whether a value meets a condition before taking action. There are two types of conditional structures in PL/SQL: the IF statement and the CASE statement. The IF statement that has two subtypes: if-then-else and if-then-elsif-then-else. The elsif is not a typo but the correct reserved word in PL/SQL, as well as Pascal and Ada programming ...