C H A P T E R  3

Looping and Logic

Any substantial program always contains some conditional logic or looping. Oftentimes, both looping and logic are combined to make powerful solutions. The recipes in this chapter will show you some examples using basic conditional logic. Once you've mastered the art of conditional logic, then you will learn how to perform all the loop types that are available in PL/SQL. Lastly, you will see some useful examples that put these concepts into action.

For the purposes of this chapter, it is important to note that a condition is any variable or expression that evaluates to a boolean. Conditions can contain one or more variables or expressions, but they must always evaluate to either TRUE, FALSE, or NULL.