Sequences Editor (Oracle)
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
- Open an editor on the sequence. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab | Settings and tasks | |
---|---|---|
Definition |
Lets you work with settings in the following categories: | |
Parameters |
Lets you specify increment, minimum value and maximum value settings. | |
Current/Next Sequence Numbers |
Lets you work with sequence cycle numbers. | |
Options |
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. | |
Dependencies |
For details on using this tab, see Working with Object Dependencies. | |
Privileges |
For details on using this tab, see Working with Privileges and Permissions. | |
DDL |
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.