Note
This view is available starting with V2.2.77.
Purpose
This view displays all sequences in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SEQUENCE_OWNER | VARCHAR2(128) | NO | The name of the database where the sequence is located. |
| SEQUENCE_NAME | VARCHAR2(128) | NO | The name of the sequence. |
| MIN_VALUE | NUMBER(28) | NO | The minimum value that can be taken by the SEQUENCE (inclusive of the minimum value). |
| MAX_VALUE | NUMBER(28) | NO | The maximum value that can be taken by the SEQUENCE (inclusive of the maximum value). |
| INCREMENT_BY | NUMBER(28) | NO | The step size for each value taken, which can be a positive or negative integer but cannot be 0. |
| CYCLE_FLAG | CHAR(1) | NO | Indicates whether the sequence can cycle. |
| ORDER_FLAG | CHAR(1) | NO | Indicates whether the values are guaranteed to be globally ordered. |
| CACHE_SIZE | NUMBER(28) | NO | The number of cached values on each node. |
| LAST_NUMBER | NUMBER(38) | NO | The value to be allocated to the next node. |
Sample query
Query the detailed information of all sequences in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_SEQUENCES;
The query result is as follows:
+----------------+---------------+-----------+------------------------------+--------------+------------+------------+------------+-------------+
| SEQUENCE_OWNER | SEQUENCE_NAME | MIN_VALUE | MAX_VALUE | INCREMENT_BY | CYCLE_FLAG | ORDER_FLAG | CACHE_SIZE | LAST_NUMBER |
+----------------+---------------+-----------+------------------------------+--------------+------------+------------+------------+-------------+
| SYS | SEQ_T1 | 1 | 9999999999999999999999999999 | 1 | N | N | 50 | 10050 |
+----------------+---------------+-----------+------------------------------+--------------+------------+------------+------------+-------------+
1 row in set
References
Query the sequences accessible to the current user: ALL_SEQUENCES
Query the sequences owned by the current user: USER_SEQUENCES