Oracle® PL/SQL® Interactive Workbook, Second Edition

Chapter 5. Conditional Control: IF Statements

Chapter Objectives In this Chapter, you will learn about: ✓ IF Statements ✓ ELSIF Statements ✓ Nested IF Statements

In almost every program that you write, you need to make decisions. For example, if it is the end of the fiscal year, bonuses must be distributed to the employees based on their salaries. In order to compute employee bonuses, a program needs to have a conditional control. In other words, it needs to employ a selection structure (you learned about selection structure in Chapter 1).

Conditional control allows you to control the flow of the execution of the program based on a condition. In programming terms, it means that the statements in the program are not executed sequentially. Rather, ...