Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sequence number
Please check the value [INCREMENT_BY].
INCREMENT_BY shold be 1 if you want to increase 1 at a time.
select SEQUENCE_NAME, INCREMENT_BY, LAST_NUMBER from user_sequences; Received on Fri Nov 12 2004 - 00:00:10 CST