Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_SEQUENCES

ALL_SEQUENCES describes all sequences accessible to the current user.

Related Views

Column Datatype NULL Description
SEQUENCE_OWNER VARCHAR2(128) NOT NULL Owner of the sequence
SEQUENCE_NAME VARCHAR2(128) 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)   Indicates whether the sequence wraps around on reaching the limit (Y) or not (N)
ORDER_FLAG VARCHAR2(1)   Indicates whether sequence numbers are generated in order (Y) or not (N)
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.

For session sequences, the value in this column should be ignored.

PARTITION_COUNT NUMBER   Number of partitions in the sequence
SESSION_FLAG VARCHAR2(1)   Indicates whether sequence values are session private (Y) or not (N).
KEEP_VALUE VARCHAR2(1)   Indicates whether sequence values are kept during reply after a failure (Y) or not (N)