Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using UPDATE with ROWNUM?

Re: Using UPDATE with ROWNUM?

From: Chris L. <diversos_at_uol.com.ar>
Date: Tue, 26 Jun 2007 13:17:39 -0700
Message-ID: <1182889059.223121.86290@o61g2000hsh.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US