CHAPTER 4Control Structures

This chapter examines the control structures in PL/SQL. Control structures let you make conditional choices, repeat operations, and access data. The IF and CASE statements let you branch program execution according to one or more conditions. Loop statements let you repeat behavior until conditions are met. Cursors let you access data one row or one set of rows at a time.

The chapter is divided into the following sections:

Image Conditional statements

Image IF statements

CASE statements

Conditional compilation statements

Iterative ...

Get Oracle Database 11g PL/SQL Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.