Online Documentation for SQL Manager for Oracle
Use the Sequence tab of Sequence Editor to create/edit a sequence and specify its properties.
Specify the name of the sequence to be created, or view the name of the sequence being edited. Note that the sequence name must be unique within its schema.
Use the drop-down list to specify the schema in which the sequence will be created.
Specify the first sequence number to be generated, or select DEFAULT from the drop-down list. Use this setting to start an ascending sequence at a value greater than its minimum or to start a descending sequence at a value less than its maximum.
Specify which value is added to the current sequence value to create a new value, or select DEFAULT from the drop-down list. A positive value will make an ascending sequence, a negative one - a descending sequence. The default value is 1.
Specify the minimum value of the sequence, or select DEFAULT from the drop-down list.
Specify the maximum value for the sequence, or select DEFAULT from the drop-down list.
Specify how many sequence numbers are to be preallocated and stored in memory for faster access, or select DEFAULT or NOCACHE from the drop-down list.
This option indicates that the sequence continues to generate values after reaching either its maximum or minimum value. After an ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum value.
Use this option to guarantee that sequence numbers are generated in order of request.
Check this option if you want NEXTVAL to retain its original value during replay for Application Continuity.
Check this option to create a session sequence, which is a special type of sequence that is specifically designed to be used with global temporary tables that have session visibility. A session sequence returns a unique range of sequence numbers only within a session, but not across sessions.