oracle 游标

 

游标
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;