ALL_SEQUENCES

Related Views

USER_SEQUENCES describes all sequences owned by the current user. This view does not display the SEQUENCE_OWNER column.

Column

Datatype

NULL

Description

SEQUENCE_OWNER

VARCHAR2(30)

NOT NULL

Name of the owner of the sequence

SEQUENCE_NAME

VARCHAR2(30)

NOT NULL

Sequence name

MIN_VALUE

NUMBER

Minimum value of the sequence

MAX_VALUE

NUMBER

Maximum value of the sequence

INCREMENT_BY

NUMBER

NOT NULL

Value by which sequence is incremented

CYCLE_FLAG

VARCHAR2(1)

Does sequence wrap around on reaching limit

ORDER_FLAG

VARCHAR2(1)

Are sequence numbers generated in order

CACHE_SIZE

NUMBER

NOT NULL

Number of sequence numbers to cache

LAST_NUMBER

NUMBER

NOT NULL

Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used.