Oracle DatabaseSequences


Syntax

  • CREATE SEQUENCE SCHEMA.SEQUENCE { INCREMENT BY INTEGER | START WITH INTEGER | MAXVALUE INTEGER | NOMAXVALUE INTEGER | MINVALUE INTEGER | NOMINVALUE INTEGER | CYCLE INTEGER | NOCYCLE INTEGER | CACHE | NOCACHE | ORDER | NOODER }

Parameters

ParameterDetails
schemaschema name
increment byinterval between the numbers
start withfirst number needed
maxvalueMaximum value for the sequence
nomaxvalueMaximum value is defaulted
minvalueminimum value for the sequence
nominvalueminimum value is defaulted
cycleReset to the start after reaching this value
nocycleDefault
cachePreallocation limit
nocacheDefault
orderGuarantee the order of numbers
noorderdefault