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.
After completing this lab, you will be ...