Creating Database Sequences
Using Sequences
3-26 Oracle Database 2 Day Developer's Guide
3.
In the New Sequence window, enter the following parameters:
Ensure that Schema is set to
HR
.
Set Name to
EVALUATIONS_SEQ
.
In the Properties tab:
Set Increment to
1
.
Set Start with to
1
.
Check Order.
Click OK.
You have now created a sequence that can be used for the primary key of the
evaluations
table. If you click '+' to expand the Sequence tree, you can see new
sequence. The equivalent SQL statement is:
