Forall limit 2005-05-12 - By Connor McDonald
Assuming you are fetching the records from somewhere in the first
place you would do something like:
open cursor
loop
bulk collect limit 500 into r
forall i in 1 .. r.count
delete...
exit when r.count < 500
end loop
close cursor
Of course, ideally you might be better off just with "delete where ... "
hth
connor
On 5/12/05, cichomitiko gmail <cichomitiko@(protected)> wrote:
> Thank you!
> May be I have to try something like:
>=20
> FORALL e IN 1..1000 -- bulk-bind first part of varray
> DELETE PUSH_LIST_DELIVERY
> WHERE ID_MSG_LIST=3Dt_ID_MSG_LIST(e);
>=20
> FORALL e IN 1001..cont_tot -- bulk-bind the rest of varray
> DELETE PUSH_LIST_DELIVERY
> WHERE ID_MSG_LIST=3Dt_ID_MSG_LIST(e);
>=20
> But I have to control the number of recors returned, so for example, if i=
t's
> 3000, then it should be:
>=20
--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
email: connor_mcdonald@(protected)
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l
|
|
