A sequence is a database object used to generate unique, incrementing or decrementing number sequences.
One sequence can be shared by multiple tables, with each table able to use the sequence to generate unique primary key values.
The value of a sequence in the database is persistent, meaning that even if the database is restarted, the value of the sequence will still be retained.
The values of the sequence can be pre-cached to improve performance.
The sequence can be incremented or decremented by a specified step, and also have minimum and maximum values set.
Sequences can be directly referenced in a table’s column or SQL statement to generate unique sequence values.
