Feature
DBA_SEQUENCES displays all sequences under the current tenant.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| SEQUENCE_OWNER | VARCHAR2(128) | NO | The name of the database in which the sequence resides. |
| SEQUENCE_NAME | VARCHAR2(128) | NO | The name of the sequence. |
| MIN_VALUE | NUMBER(28) | NO | The minimum value. |
| MAX_VALUE | NUMBER(28) | NO | The maximum value. |
| INCREMENT_BY | NUMBER(28) | NO | The step size. |
| 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 the sequence is ordered. |
| CACHE_SIZE | NUMBER(28) | NO | The cache size. |
| LAST_NUMBER | NUMBER(38) | NO | The previous value. |