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: joel garry <joel-garry_at_home.com>
Date: Wed, 27 Jun 2007 15:06:46 -0700
Message-ID: <1182982006.101947.222330@a26g2000pre.googlegroups.com>


On Jun 27, 6:55 am, Jagjeet Singh <jagjeet.ma..._at_gmail.com> wrote:
> 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.

Um, you might want to peruse this internet thingee about commit in loop and ora-1555, for example at asktom.oracle.com, especially if there is a performance requirement.

jg

--
@home.com is bogus.
If at first you don't succeed, please don't be a test pilot.
http://cfx.signonsandiego.com/news/northcounty/20070619-9999-1m19plane.html
(My wife was going to pick up the kids and gave me a call asking if I
knew what all the people were running up to the freeway fence and
gawking about)
Received on Wed Jun 27 2007 - 17:06:46 CDT

Original text of this message

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