Oracle Sequences DDL


CREATE Sequence

Sequences allow for automatic generation of sequential non-repeating or repeating integer values for use in keys or elsewhere. Sequences can be positive or negative. Also a number of values can be cached for performance. However, in the case of a database shut down these cached values are lost. If a statement that references a sequence is rolled back that sequence number will be lost.

ALTER Sequence

Use ALTER SEQUENCE to change minimum, maximum, caching and increment parameter values. Note that future sequence values only are affected by ALTER SEQUENCE. START WITH can only be altered by dropping and recreating the sequence.

DROP Sequence