Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E25519-05 |
|
|
PDF · Mobi · ePub |
With each iteration of the basic LOOP
statement, its statements run and control returns to the top of the loop. The LOOP
statement ends when a statement inside the loop transfers control outside the loop or raises an exception.
LNPLS944Topics
LNPLS1232basic_loop_statement ::=
See "statement ::=".
LNPLS945statement
To prevent an infinite loop, at least one statement must transfer control outside the loop. The statements that can transfer control outside the loop are:
"CONTINUE Statement" (when it transfers control to the next iteration of an enclosing labeled loop)
LNPLS1243label
A label that identifies basic_loop_statement
(see "statement ::=" and "label"). CONTINUE
, EXIT
, and GOTO
statements can reference this label.
Labels improve readability, especially when LOOP
statements are nested, but only if you ensure that the label ine the END
LOOP
statement matches a label at the beginning of the same LOOP
statement (the compiler does not check).
Example 4-10, "Basic LOOP Statement with EXIT WHEN Statement"
Example 4-11, "Nested, Labeled Basic LOOP Statements with EXIT WHEN Statements"
Example 4-13, "CONTINUE WHEN Statement in Basic LOOP Statement"
LNPLS947In this chapter:
LNPLS948In other chapters: