Cursor For Loops

I understand that a cursor for loop is a loop transaction that automatically opens a cursor, fetches its contents into a special record structure and then closes the cursor. However, can someone tell me (using the following example) how the loop determines where it will terminate. (I.e., what is the relevance of C1_RECORD).

Here we go...

DECLARE
  CURSOR C1
  IS SELECT R.SURNAME, R.CURSAL, R.BORN FROM RECRUIT R; BEGIN
  FOR F1 IN F1_RECORD LOOP

         IF F1_RECORD.SURNAME = 'WHATEVER'
         THEN and so on and so on ...

  END LOOP; END; thanks v. much

Best regards

R.W. Fairbairn Received on Fri May 22 1998 - 05:43:01 CDT