Note
This view is introduced since OceanBase Database V2.2.77.
Purpose
The ALL_SEQUENCES view displays all sequences accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_SEQUENCES
USER_SEQUENCES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| OBJECT_NAME | VARCHAR2(128) | NO | The name of the sequence. |
| MIN_VALUE | NUMBER(28) | NO | The minimum value of the sequence. |
| MAX_VALUE | NUMBER(28) | NO | The maximum value of the sequence. |
| INCREMENT_BY | NUMBER(28) | NO | The step size by which the sequence is incremented, which can be a positive or negative integer but cannot be 0. |
| CYCLE_FLAG | CHAR(1) | NO | Indicates whether the sequence wraps when it reaches the minimum or maximum value. |
| ORDER_FLAG | CHAR(1) | NO | Indicates whether sequence values are generated in order. |
| CACHE_SIZE | NUMBER(28) | NO | The number of sequence values stored in the cache. |
| LAST_NUMBER | NUMBER(38) | NO | The value of the last sequence number written to the disk. |