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

August 7, 2016 · 1 min · 98 words · Larry Nung | Suggest Changes

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

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

LOOP
FETCH c_employees INTO r_employee;
EXIT WHEN NOT c_employees%FOUND;
...
END LOOP;

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

LOOP
FETCH c_employees INTO r_employee;
EXIT WHEN c_employees%NOTFOUND;
...
END LOOP;

這樣可讀性會比較好。