Oracle Database Sequences
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
| Parameter | Details |
|---|---|
| schema | schema name |
| increment by | interval between the numbers |
| start with | first number needed |
| maxvalue | Maximum value for the sequence |
| nomaxvalue | Maximum value is defaulted |
| minvalue | minimum value for the sequence |
| nominvalue | minimum value is defaulted |
| cycle | Reset to the start after reaching this value |
| nocycle | Default |
| cache | Preallocation limit |
| nocache | Default |
| order | Guarantee the order of numbers |
| noorder | default |
