it comes under explicit cursor, Cursor FOR LOOP automatically opens the cursor, loops through each row in the result set, and closes the cursor.