SQL%NOTFOUND

SQL%NOTFOUND

 

---SQL%NOTFOUND，没有记录被修改，返回TRUE
declare
begin
  insert into eep.users (userid, pwd) values ('002', '00002');
  dbms_output.put_line('SQL%NOTFOUND=' || CASE SQL%NOTFOUND WHEN TRUE THEN
                       'TRUE' ELSE 'FALSE' END || CHR(10));
end;

 

执行截图：