Understanding control structures
Setting up conditions
Looping through commands
Every programming language has the ability to use logic to control what statements execute next. PL/SQL is no different in this regard. PL/SQL supports IF...THEN, CASE, and LOOP statements.
If you’re an experienced programmer, you can probably just skim this chapter for the PL/SQL-specific syntax. You won’t be missing anything important.
If you have studied programming only in school or are a novice programmer, you should probably read this chapter carefully to make sure that you understand all these structures.
To solve a programming problem, you can write programs by using one of two types of control structures:
Conditional statements: In this case, the execution path is divided into branches depending upon the condition. If the condition is true, one path is followed; if false, a different path is used. These true or false conditions are called Boolean (meaning they can only have two states, such as on/off, yes/no, true/false) conditions.