游标
1 cursor cur_para(id varchar2) is --参数只给类型
select bname from books where book.id=id;
t_name book.bname%type;
begin
open cur_para('001');
loop
fetch cur_para into t_name;
exit when cur_para%notfound;
dbms_output.put_line(t_name);
end loop;
close cur_para;
end;
2 for mycur into cur_para('001') loop
dbms_output.put_line(mycur.bname);
end loop
end;
3 declare
if cur%ispoen then
4 %rowcount 每次取完数据rowcount都有加1
5 修改数据的游标定义
cursor cur is
select bname from books for update ;
text varchar2(20);
while cur%found loop
update books set bname='a'||'t' where current of cur;
fetch cur into text;
end loop;
end;
6 隐式游标(看不到定义 打开 取 关)大量数据时不用游标
begin
for cur in(select name from books )loop
dbms_output.put_line(cur.name);
end loop;
end;