Loops (PL/SQL)

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.
FOR (integer variant) statement (PL/SQL)
Use the FOR statement to execute a set of SQL statements more than once.
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.

Parent topic: Control statements (PL/SQL)

Updates to this topic are made in English and are applied to translated versions at a later date. Consequently, the English version of this topic always contains the most recent updates.

See when the translated version of this topic was last updated.
See when the English version of this topic was last updated.