begin
UPDATE authors SET au_lname = 'Jones'
WHERE au_id = '999-888-7777';
IF sql%ROWCOUNT = 0 then
dbms_output.put_line( 'Warning: No rows were updated');
end if;
end;
/
UPDATE authors SET au_lname = 'Jones'
WHERE au_id = '999-888-7777';
IF sql%ROWCOUNT = 0 then
dbms_output.put_line( 'Warning: No rows were updated');
end if;
end;
/
有什么函数与之对应阿
返回被 FETCH 语句执行的最后游标的状态,而不是任何当前被连接打开的游标的状态。sql%notfound