<< Click to Display Table of Contents >>

Overview Sequences

Top Previous Next

Overview Sequences is the default sheet. It shows the following information about the current user's sequences:

Sequence name

Minimum value of the sequence

Maximum value of the sequence

Increment By, i.e. value by which sequence is incremented

Cycle, i.e. does sequence wrap around on reaching the limit?

Order, i.e. are sequence numbers generated in order?

Cache size, i.e. number of sequence numbers to cache

Last number, i.e. last sequence number written to disk. The next reference to SEQUENCE.NEXTVAL will return a number between LAST_NUMBER-CACHE_SIZE+1 AND LAST_NUMBER+1..

Progress, i.e. position of last_number in the range of min_value and max_value, expressed as a percentage

Time stamp of creation

Last DDL time

Status

 

The following context operations are available:

39_Sequence

Create

Creates a new sequence.

07_Drop

Drop

Drops a sequence.

05_Properties

Properties/Alter

Views and modifies sequence properties.

40_Increment

Increment

Increments the sequence to a higher number.

 

Copy to clipboard

Creates a "SELECT sequence.CURRVAL FROM DUAL" statement and copies it into the Windows clipboard.

139_ShowDDL

Show DDL

Generates DDL for the sequence to a file

 

Grid View

For more information, see object window