Re: Using UPDATE with ROWNUM?

From: Jagjeet Singh <jagjeet.malhi_at_gmail.com>
Date: Wed, 27 Jun 2007 06:55:07 -0700
Message-ID: <1182952507.174266.300580@w5g2000hsg.googlegroups.com>

On Jun 27, 6:49 pm, Jagjeet Singh <jagjeet.ma..._at_gmail.com> wrote:
> > I don't know what this is other than one of the worst examples of PL/SQL
> > I have seen in a very long time. And I teach students new to PL/SQL.
>
> what other way you can suggest ?

Simple and Best and Fastest way is to use just single update, No intermediate commit which may leave
you with inconsistent data. But he mentioned he can not take a lock more than few seconds. Received on Wed Jun 27 2007 - 08:55:07 CDT