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

Home -> Community -> Usenet -> c.d.o.tools -> Re: question on oracle sequences

Re: question on oracle sequences

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Thu, 08 Mar 2001 18:22:45 GMT
Message-ID: <3AA7CBF0.2070208@sympatico.ca> 






Hi,


By default it will increment the sequence by 1...you can change this by 
setting the INCREMENT BY parameter (e.g. INCREMENT BY 5, INCREMENT BY -2 
etc)


Hope this helps,


Steve



Igor Aptekar wrote:



> Does an oracle sequence always allocated numbers contiguously? Are there any

> conditions under which it wouldn't do this?

> 

> thanks

> 

> 

Received on Thu Mar 08 2001 - 12:22:45 CST












Original text of this message













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