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

Home -> Community -> Usenet -> c.d.o.misc -> Re: User Sequence Skipping Numbers???

Re: User Sequence Skipping Numbers???

From: webbo <hughjanus_at_my-dejanews.com>
Date: Wed, 07 Apr 1999 16:09:53 GMT
Message-ID: <7eg009$9hj$1@nnrp1.dejanews.com>


Selecting Max valus can cause problems if more than one user selects it before the new row is commited, unless you use SELECT FOR UPDATE, thereby locking it.

>
>

Webbo

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 11:09:53 CDT

Original text of this message

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