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. ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.