oracle 批量提交

两种方式实现oracle批量提交

方式一：利用 fetch .. bulk collect into .. limit limitnumber;--limitnumber批量提交条数

declare Cursor  dataCursors 
    is

  /*定义游标*/  

;

 type dataCursor is table of tablename%rowtype;
    dataCursorP dataCursor;
    
    begin
      open dataCursors;
        while (true) loop
          fetch dataCursors bulk collect into dataCursorP limit 50;