Sequence Designer
The Sequence Designer lets you create or modify sequences. This section covers the following topics:
Creating Sequences in Oracle Developer Tools
Use the Sequence Designer to create or modify sequences. To create a sequence in your own schema, you must have the CREATE
SEQUENCE
system privilege. To create a sequence in another user's schema, you must have the CREATE
ANY
SEQUENCE
system privilege.
Starting the Sequence Designer
Start the Sequence Designer by using one of the following methods:
-
If you are creating a new sequence, in Server Explorer, right-click the Sequences node and from the menu, select New Sequence.
-
If you are modifying an existing sequence, in Server Explorer, double-click the node that represents that sequence, or right-click the node and select Edit.
The Sequence Designer appears similar to the following:
Using the Sequence Designer
The Sequence Designer has the following controls:
Control | Description |
---|---|
Schema name |
Select from the list of available schemas in which to create the sequence. |
Sequence name |
Enter a name for the sequence. |
Type |
Select either of the following:
|
Values |
Specifies the range of values to use for the sequence.
|
Options |
Select from the following settings:
|
Preview SQL |
Displays the |
Save |
Commits the sequence to the database. Alternatively, you can click the Save button in the Visual Studio .NET toolbar or select Save from the File menu. |
See Also