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