Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: User Sequence Skipping Numbers???
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
![]() |
![]() |