PL/SQL SQL Coding Guideline 41 - Always use a cursor FOR loop to process the complete cursor results unless you are using BULK operations

條款四十一，總是使用 CURSOR for loop，除非使用 Bulk operations。

像是下面這樣的程式：

...
BEGIN 
  <<read_employees>> 
  LOOP
    FETCH c_employees INTO r_employee;  
	EXIT read_employees WHEN c_employees%NOTFOUND;
    … 	
  END LOOP read_employees; 
  CLOSE c_employees;
END;

可以像下面這樣改寫，程式碼的維護性會比較好。

...
BEGIN 
  <<read_employees>> 
  FOR r_employee IN c_employee 
  LOOP 
    … 
  END LOOP read_employees; 
END;