O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, 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 8 Iterative Control

Lab 8.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) C If there is no EXIT condition specified, a simple loop becomes an infinite loop. In other words, a sequence of statements will be executed an infinite number of times because there is no statement specifying when the loop must terminate.
A2:
Questions Answers Comments
2) B As soon as the EXIT statement is encountered, the loop is terminated.
A3:
Questions Answers Comments
3) A As long as the EXIT condition does not evaluate to TRUE, the control is never transferred to the EXIT statement. This will prevent a loop from terminating. For example,

IF x > 5 THEN 
   EXIT; 
END IF; 
In this case, the EXIT condition is a test condition of the IF statement. ...

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