Basic LOOP Statement

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 when an exception is raised.

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

basic_loop_statement ::=

Description of the illustration basic_loop_statement.gif

See statement ::=.

Semantics

label

A label that identifies basic_LOOP_statement (see 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 at the end of the LOOP statement matches one of the labels at the beginning of the same statement (the compiler does not check).

statement

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)

• "EXIT Statement"

• "GOTO Statement"

• "RAISE Statement"

Examples

• Example 1-2, "Processing Query Result Rows One at a Time"

• Example 4-9, "Basic LOOP Statement with EXIT Statement"

• Example 4-10, "Basic LOOP Statement with EXIT WHEN Statement"

• Example 4-11, "Nested, Labeled Basic LOOP Statements with EXIT WHEN Statements"

• Example 4-12, "CONTINUE Statement in Basic LOOP Statement"

• Example 4-13, "CONTINUE WHEN Statement in Basic LOOP Statement"

Related Topics

In this chapter:

• "Cursor FOR LOOP Statement"

• "FOR LOOP Statement"

• "WHILE LOOP Statement"

In other chapters:

• "Basic LOOP Statement"