Oracle中游标Cursor的介绍

游标就是为了不频繁访问磁盘而存在的东西。
就好像redis一样，类似于一个缓存。

游标

  定义游标—Cursor [Cursor Name] IS;
  打开游标—Open [Cursor Name];
  操作数据—Fetch [Cursor name]

Set serveroutput on;  
  
declare   
    ---define Cursor  
    Cursor cur_policy is  
     select cm.policy_code, cm.applicant_id, cm.period_prem,cm.bank_code,cm.bank_account  
     from t_contract_master cm  
     where cm.liability_state = 2  
     and cm.policy_type = 1  
     and cm.policy_cate in ('2','3','4')  
     and rownum < 5  
     order by cm.policy_code desc;  
    curPolicyInfo cur_policy%rowtype;---定义游标变量  
Begin  
   open cur_policy; ---open cursor  
   Loop   
     --deal with extraction data from DB  
     Fetch cur_policy into curPolicyInfo;  
     Exit when cur_policy%notfound;  
           
     Dbms_Output.put_line(curPolicyInfo.policy_code);  
   end loop;  
   Exception   
     when others then  
         close cur_policy;  
         Dbms_Output.put_line(Sqlerrm);  
           
   if cur_policy%isopen then    
    --close cursor   
      close cur_policy;  
   end if;  
end;  
  
/  

--------------------- 
作者：死磕JAVA的老司机 
来源：CSDN 
原文：https://blog.csdn.net/mydreamneverstop/article/details/78604033 
版权声明：本文为博主原创文章，转载请附上博文链接！