Re: Optimize Select on update column

May be we are talking about different things here. What I meant is, a forall can be used only for Inserts, updates or deletes. Now processing sounds more like pl/sql routines than sqls.. If I have to update without any other processing I would simply do UPDATE Table1
SET status = 'Y'
WHERE status = 'N'
AND non_unique_key_code = <key>;
rathen than doing bulk bind and for all...

Regards,
Kal

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1076606636.319173_at_yasure>...
> Kalmact wrote:
>
> > egkua,
> > If you have any processing in between you would not be able to use forall.
>
> Where did you get that idea?
>
> The URL I posted: http://www.psoug.org/reference/bulk_collect.html
>
> has an example of exactly what you just claimed couldn't be done. And
> there are other ways to accomplish it other than the one demonstrated
> on the above URL.
Received on Fri Feb 13 2004 - 03:26:35 CST