The DBA_SEQUENCES view provides the information about all user-defined sequences.
Parameter | Type | Description |
---|---|---|
sequence_owner | TEXT | The username of the owner to which the sequence belongs. |
schema_name | TEXT | The name of the schema to which the sequence belongs. |
sequence_name | TEXT | The name of the sequence. |
min_value | NUMERIC | The minimum value that the server assigns to the sequence. |
max_value | NUMERIC | The maximum value that the server assigns to the sequence. |
increment_by | NUMERIC | The value added to the current sequence number to create the next sequence number. |
cycle_flag | CHARACTER VARYING | Indicates whether the sequence wraps if it reaches min_value or max_value. |
order_flag | CHARACTER VARYING | This parameter always returns the value of Y. |
cache_size | NUMERIC | The number of preallocated sequence numbers stored in memory. |
last_number | NUMERIC | The value of the last sequence number saved to the disk. |