O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7 Iterative Control: Part II

CHAPTER OBJECTIVES

In this chapter, you will learn about

• The CONTINUE statement

• Nested loops

In the preceding chapter you explored three types of loops: simple loops, WHILE loops, and numeric FOR loops. You also learned that these types of loops can be terminated with the EXIT condition. In this chapter you will learn about a new PL/SQL feature introduced in Oracle 11g called the CONTINUE condition. Similar to the EXIT condition, the CONTINUE condition has two forms, CONTINUE and CONTINUE WHEN, and it may be used inside the body of the loop only. You will also learn how to nest these types of loops inside one another.

Lab 7.1 The CONTINUE Statement

LAB OBJECTIVES

After completing this lab, you will be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required