fetch 的使用

//批量

create or replace procedure testfetch is
   cursor cur_normal is
       select t.content_id from epp_t_content t
         where rownum < 3;
  
    TYPE ID_TAB_TYPE IS TABLE OF epp_t_send_content_status.content_id%type
       INDEX BY BINARY_INTEGER;
   contentIdNormalBuffer ID_TAB_TYPE;
  
   contentId char(10);

   begin
      open cur_normal;
      loop
         
          fetch  contentIdNormalBuffer bulk collect into contentId;
               for i contentIdNormalBuffer.First
               dbms_output.put_line('1');   
              
              exit when cur_normal%notfound;
          end loop;
         
   close cur_normal;
end testfetch;

 

//单条

 

 

create or replace procedure testfetch is
   cursor cur_normal is
       select t.content_id from epp_t_content t
         where rownum < 3;
  
    TYPE ID_TAB_TYPE IS TABLE OF epp_t_send_content_status.content_id%type
       INDEX BY BINARY_INTEGER;
   contentIdNormalBuffer ID_TAB_TYPE;
  
   contentId char(10);

   begin
      open cur_normal;
      loop
         
          fetch cur_normal  into contentId;
            exit when cur_normal%notfound;
               dbms_output.put_line('1');   
              
             
          end loop;
         
   close cur_normal;
end testfetch;

 

 

 

转载于:https://www.cnblogs.com/talk/archive/2011/08/01/2124158.html