4.72 ALL_SEQUENCES
ALL_SEQUENCES
describes all sequences accessible to the current user.
Related Views
-
DBA_SEQUENCES
describes all sequences in the database. -
USER_SEQUENCES
describes all sequences owned by the current user. This view does not display theSEQUENCE_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the sequence |
|
|
|
Sequence name |
|
|
|
Minimum value of the sequence |
|
|
|
Maximum value of the sequence |
|
|
|
Value by which sequence is incremented |
|
|
|
Indicates whether the sequence wraps around on reaching the limit ( |
|
|
|
Indicates whether sequence numbers are generated in order ( |
|
|
|
Number of sequence numbers to cache |
|
|
|
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. |
|
|
|
Indicates whether this is a scalable sequence ( |
|
|
|
Indicates whether this scalable sequence’s generated values extend beyond |
|
|
|
Indicates whether this is a sharded sequence ( |
|
|
|
Indicates whether sequence values are session private ( |
|
|
|
Indicates whether sequence values are kept during replay after a failure ( |
See Also: