Chapter 6 : PL/SQL Control Structure (Conditional Statement - If-Else, Case & Loops)
This chapter shows you how to structure the flow of control through a PL/SQL program. You learn how statements are connected by simple but powerful control structures that have a single entry and exit point. Collectively, these structures can handle any situation. Their proper use leads naturally to a well-structured program.
This chapter discusses the following topics:
Overview of PL/SQL Control Structures
Conditional Control: IF and CASE Statements
Iterative Control: LOOP and EXIT Statements
Sequential Control: GOTO and NULL Statements