Sequence Name

Sequence name (sequence_name)

Schema

Schema name (schema_name)

Start With

First value of the sequence

Increment By

Difference between two successive values of the sequence

A negative value generates a descending sequence.

Default value: 1

Minimum Value

Minimum value

Maximum Value

Maximum value

Values to Cache

Number of values of the sequence that the system stores in the sequence cache

Cycle

Ascending sequences: after the system has reached the maximum value, it allocates the minimum value as next value.

Descending sequences: after the system has reached the minimum value, it allocates the maximum value as next value.