r_emp scott.emp%rowtype;
cursor cur_emp
is
select t.
* from scott.emp t;
begin
open cur_emp;
if cur_emp
%isopen
then
dbms_output.put_line(‘is open...‘);
end if;
loop
fetch cur_emp
into r_emp;
if cur_emp
%found
then
dbms_output.put_line(‘found...‘);
end if;
if cur_emp
%notfound
then
dbms_output.put_line(‘not found...‘);
end if;
exit when cur_emp
%notfound;
dbms_output.put_line(cur_emp%rowcount || ‘ -> ‘ || r_emp.empno
||
‘ ‘ || r_emp.sal);
end loop;
close cur_emp;
end;
Oracle PLSQL Demo - 13.游标的各种属性[Found NotFound ISOpen RowCount CURSOR]
标签：
本文系统来源：http://www.cnblogs.com/nick-huang/p/4609089.html
【说明】：
本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！