[label :] LOOP ON <select statement> AS <cursorname>
statement
Loop Statement
A LOOP statement is an iterative control construct that is used to cursor through a result set.
Usage
Syntax rules
-
The label must not be the same as any label that is used in statements that contain this one.