7

Iterative Control: Part II

In Chapter 6, “Iterative Control: Part I,” you explored three types of loops: simple loops, WHILE loops, and numeric FOR loops. You also learned about numeric FOR loop enhancements introduced in Oracle 21c. In this chapter, you will continue to explore loop iteration controls and learn about the CONTINUE statement and its restrictions. Finally, you will learn how to nest different types of loops inside one another.

Lab 7.1: CONTINUE Statements

The CONTINUE statement has two forms: CONTINUE and CONTINUE WHEN.

Using the CONTINUE Statement

The CONTINUE ...

Get Oracle PL/SQL by Example, 6th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.