PL/SQL Cursor For Loop

(via www.fast-track.cc)

Oracle Tips by Burleson

1. Open the cursor.
2. Start a loop.
3. Fetch a row of data.
4. Check for a new row, exit if not.
5. Process the data.
6. End the loop.
7. Close the cursor.

Since these steps are almost always followed, Oracle provides a way to let PL/SQL perform most of the steps. This is called the CURSOR FOR loop. As in the name, it uses a FOR loop to process the cursor...

Comment