Use the EXIT, FOR, LOOP, and WHILE statements to repeat
a series of commands in your PL/SQL program.
FOR (cursor variant) statement (PL/SQL)
The cursor FOR loop statement opens a previously declared
cursor, fetches all rows in the cursor result set, and then closes
the cursor.
FORALL statement (PL/SQL)
The FORALL statement executes a data change statement for
all elements of an array or for a range of elements of an array.
EXIT statement (PL/SQL)
The EXIT statement terminates execution of a loop within
a PL/SQL code block.
LOOP statement (PL/SQL)
The LOOP statement executes a sequence of statements within
a PL/SQL code block multiple times.
WHILE statement (PL/SQL)
The WHILE statement repeats a set of SQL statements as
long as a specified expression is true. The condition is evaluated
immediately before each entry into the loop body.
CONTINUE statement (PL/SQL)
The CONTINUE statement terminates the current iteration
of a loop within a PL/SQL code block, and moves to the next iteration
of the loop.
DB2 Version 10.1 for Linux, UNIX, and Windows