[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.