declare
cursor c is
select * from emp;
v_emp c%rowtype;
begin
open c;
fetch c into v_emp;
dbms_output.put_line(v_emp.ename);
close c;
end;
//使用游标
declare
cursor c is
select * from emp;
v_emp c%rowtype;
begin
open c;
loop
fetch c into v_emp;
exit when(c%notfound);
dbms_output.put_line(v_emp.ename);
end loop;
close c;
end;
//遍历结果集
游标有四个属性
isopen代表游标是否打开了
notfound最近的一条fetch语句没有返回记录
found最近的一条fetch语句找到了一条记录
rowcount当前已经返回的索引
cursor c is
select * from emp;
v_emp c%rowtype;
begin
open c;
fetch c into v_emp;
dbms_output.put_line(v_emp.ename);
close c;
end;
//使用游标
declare
cursor c is
select * from emp;
v_emp c%rowtype;
begin
open c;
loop
fetch c into v_emp;
exit when(c%notfound);
dbms_output.put_line(v_emp.ename);
end loop;
close c;
end;
//遍历结果集
游标有四个属性
isopen代表游标是否打开了
notfound最近的一条fetch语句没有返回记录
found最近的一条fetch语句找到了一条记录
rowcount当前已经返回的索引