Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using UPDATE with ROWNUM?
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