Sequences Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Sequences Editor lets you manage parameters for a sequence, manage database objects dependent on the sequence, and manage privileges for the sequence.

To edit a sequence

  1. Open an editor on the sequence. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you work with settings in the following categories:


Lets you specify increment, minimum value and maximum value settings.

Current/Next Sequence Numbers

Lets you work with sequence cycle numbers.


Lets you specify Cache Size, Cycle When Reach Max/Min, and Generate Numbers in Order (useful when you are using the sequence number as a timestamp) values.


For details on using this tab, see Working with Object Dependencies.


For details on using this tab, see Working with Privileges and Permissions.


For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.