oracle中的光标

 1光标的属性
      %found %notfound
      %open 判断光标是否打开
      %rowfound :影响的行数
      2.光标的限制:：默认情况下，oracle数据库只允许在同一会话中打开300个光标 
      */
        /*
   修改光标数的限制
   alter system set open_cursor=400 scope=both;
   scope的取值:both,menmory,spfile(数据库需要重启
   */
 declare cursor cemp is select empno,job from emp; pempno emp.empno%type; pjob emp.job%type; begin open cemp; if cemp%isopen then dbms_output.put_line('光标已经打开'); else dbms_output.put_line('光标没有打开'); end if; close cemp; end; -- declare cursor
 cemp is select empno,job from emp; pempno emp.empno%type; pjob emp.job%type; begin open cemp; loop fetch cemp into pempno,pjob; exit when cemp%notfound; dbms_output.put_line('rowcount'||cemp%rowcount); end loop; close cemp; end;