Example of BULK COLLECT ?


Declare

Cursor  c1 is select order_number from oe_order_headers_all ;

Type rec_type is table of oe_order_headers_all%rowtype;

order_rec_type  rec_type;

Begin

open c1;
loop
fetch c1 bulk collect into order_rec_type limit 200;
for i in 1..order_rec_type.count loop
null;
exit when c1%notfound;
end loop;
end;