PL/SQL & SQL CODING GUIDELINE 31 - Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was successful

條款三十一,Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was successful。


不要用 Not %FOUND 去撰寫判斷邏輯。

1
2
3
4
5
LOOP 
FETCH c_employees INTO r_employee;
EXIT WHEN NOT c_employees%FOUND;
...
END LOOP;


取而代之的是要用 %NOTFOUND 去撰寫判斷邏輯。

1
2
3
4
5
LOOP 
FETCH c_employees INTO r_employee;
EXIT WHEN c_employees%NOTFOUND;
...
END LOOP;


這樣可讀性會比較好。