Feature
USER_SEQUENCES describes all sequences owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_SEQUENCES
DBA_SEQUENCES
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| 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. |