ALL_SEQUENCES

ALL_SEQUENCES displays all sequences accessible to the current user.

Table 1 ALL_SEQUENCES columns

Column

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: It is a cycle sequence.

  • N: It is not a cycle sequence.