Online Documentation for SQL Manager for Oracle

Creating/editing sequence


Use the Sequence tab of Sequence Editor to create/edit a sequence and specify its properties.

 

Name

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.

 

Schema

Use the drop-down list to specify the schema in which the sequence will be created.

 

Sequence Editor - Editing sequence definition

 

Start with

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.

 

Increment

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.

 

Min value

Specify the minimum value of the sequence, or select DEFAULT from the drop-down list.

 

Max value

Specify the maximum value for the sequence, or select DEFAULT from the drop-down list.

 

Cache

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.

 

CheckBox Cycle

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.

 

CheckBox Order

Use this option to guarantee that sequence numbers are generated in order of request.

 

CheckBox Keep

Check this option if you want NEXTVAL to retain its original value during replay for Application Continuity.

 

CheckBox Session

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.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.