A sequence is a database object whose value the database system automatically increases or decreases with each access. To guarantee quick access, the database system holds the values and management information for sequences in the sequence cache.

See also:

SQL Reference Manual,

Sequence Name (sequence_name)

CREATE SEQUENCE Statement (create_sequence_statement)

SQL Tutorial, Number Generators for Tables