get_sequence_info
Retrieve metadata for a single Oracle sequence, including min/max values, increment, last number, cache, and cycle/order flags, without consuming NEXTVAL.
Instructions
Return metadata for a single sequence (min_value, max_value, increment_by, last_number, cache_size, cycle_flag, order_flag) from ALL_SEQUENCES. Read-only: does NOT consume NEXTVAL, so the sequence counter is untouched. Prefer this over querying ALL_SEQUENCES/DBA_SEQUENCES directly.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema (owner) of the object. Optional — defaults to the server's current schema; omit rather than guess. | |
| sequence | Yes | Sequence name. |