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: klabranche <kevin_labranche_at_hotmail.com>
Date: Fri, 02 Apr 1999 18:33:58 GMT
Message-ID: <q48N2.281$qT.430@c01read04.service.talkway.com>


I was just wondering...Wouldn't you have the same problems with your table as those described by Rudy Zung(the first response)?

I have gotten around this problem by using a select statement with finding the max value in the primary key field and adding one to it.

I don't know if this is the best way to get around skipping values but so far I have had no problems with it and I haven't noticed any side effect.

Kevin LaBranche
--
Posted via Talkway - http://www.talkway.com Surf Usenet at home, on the road, and by email -- always at Talkway. Received on Fri Apr 02 1999 - 12:33:58 CST

Original text of this message

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