Oracle Database Sequences

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

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


Got any Oracle Database Question?