條款三十一,Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was successful。
不要用 Not %FOUND 去撰寫判斷邏輯。1
2
3
4
5LOOP
FETCH c_employees INTO r_employee;
EXIT WHEN NOT c_employees%FOUND;
...
END LOOP;
取而代之的是要用 %NOTFOUND 去撰寫判斷邏輯。1
2
3
4
5LOOP
FETCH c_employees INTO r_employee;
EXIT WHEN c_employees%NOTFOUND;
...
END LOOP;
這樣可讀性會比較好。