MY_SEQUENCES
MY_SEQUENCES displays the sequence information about the current user. This view exists in both PG_CATALOG and SYS schemas. For details about the columns, see Table 1.
Name |
Type |
Description |
---|---|---|
sequence_owner |
name |
Owner of a sequence. |
sequence_name |
name |
Name of a sequence. |
min_value |
int16 |
Minimum value of a sequence. |
max_value |
int16 |
Maximum value of a sequence. |
increment_by |
int16 |
Value by which the sequence is incremented. |
cycle_flag |
character(1) |
Specifies whether a sequence is a cycle sequence. The options are as follows:
|
order_flag |
character varying(1) |
Specifies whether a sequence occurs in a request sequence. This parameter is not supported. Set it to NULL. |
cache_size |
int16 |
Size of the sequence disk cache. |
last_number |
int16 |
Last value of the sequence allocated in a batch from the GTM at a time. |
scale_flag |
character varying(1) |
Specifies whether a sequence is a scalable sequence. This parameter is not supported. Set it to NULL. |
extend_flag |
character varying(1) |
Specifies whether the value generated by a scalable sequence exceeds the maximum or minimum value of the sequence. Not supported. The value is NULL. |
sharded_flag |
character varying(1) |
Specifies whether a sequence is a shard sequence. Not supported. The value is NULL. |
session_flag |
character varying(1) |
Specifies whether a sequence has a private session. This is not supported. The value is NULL. |
keep_value |
character varying(1) |
Specifies whether to retain the sequence value during replay after a failure. Not supported. The value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot