Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using UPDATE with ROWNUM?
On 26 jun, 17:11, Jagjeet Singh <jagjeet.ma..._at_gmail.com> wrote:
> Bulk collect would be usefull if we are upding records one by one
> through a loop
> where we spent time in switch over from sql eng. to plsql. eng. But
> here we can do this
> directly through one update.
>
> Let see if someone else can put more info, how bulk collect would be
> usefull.
>
> Regards,
> Jagjeet Singh.
According to the original poster, using only one update would lock the table for too long. He determined that updating 1000 rows at a time resulted in a short-enough lock. Received on Tue Jun 26 2007 - 15:17:39 CDT