Help Center > > Developer Guide> System Catalogs and System Views> System Views> ALL_SEQUENCES

ALL_SEQUENCES

Updated at:Jul 15, 2020 GMT+08:00

ALL_SEQUENCES displays all sequences accessible to the current user.

Table 1 ALL_SEQUENCES columns

Name

Type

Description

sequence_owner

name

Owner of the sequence

sequence_name

name

Name of the sequence

min_value

bigint

Minimum value of the sequence

max_value

bigint

Maximum value of the sequence

increment_by

bigint

Value by which the sequence is incremented

cycle_flag

character(1)

Whether the sequence is a cycle sequence. The value can be Y or N.

  • Y indicates that it is a cycle sequence.
  • N indicates that it is not a cycle sequence.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel