/ Published in: SQL
You would use a CURSOR FOR Loop when you want to fetch and process every record in a cursor. The CURSOR FOR Loop will terminate when all of the records in the cursor have been fetched.
URL: http://www.techonthenet.com/oracle/loops/cursor_for.php