RE: PL/SQL Automatic BULK

Hi Bruce

>The presentation went into detail about not all queries will
>use array processing - only 'static sql cursor for loop' which
>in the presentation has the form
>
>for j in (select ...  From tbl)
>Loop
>Yada yada;
>End loop;

This is true. In fact a PL/SQL block like the following doesn't use =
prefetching.

declare
  cursor c is select * from all_tables;
  t all_tables%rowtype;
begin
  open c;
  loop=20
    fetch c into t;
    exit when c%notfound;
  end loop;
end;


HTH
Chris
--
http://www.freelists.org/webpage/oracle-l

Other related posts: