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 -> Order of sequence number generation

Order of sequence number generation

From: Sabarinath Nair <snair_at_mit.edu>
Date: 1997/10/22
Message-ID: <344E51DE.5E125716@mit.edu>#1/1 







Hello,



I have a sequence created using the foolowing SQL.



create sequence SEQ_MESSAGE_ID INCREMENT BY 1 START WITH 100 maxvalue
999999999999 ORDER;


When I use this sequence, thru a stored procedure, the sequence numbers
which are generated are not incrimented by 1. instead it gets increments
of 20.  1, 21, 42 etc...



Does any one know how to get around this...




Thanks


Sabari
Received on Wed Oct 22 1997 - 00:00:00 CDT












Original text of this message













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