Oracle Sequence Function

The Oracle Sequence Function assigns a value to the destination column by using an Oracle Sequence.

schema.seqname.NEXTVAL [INCL_UPD]

schema
Qualifier for the Oracle Sequence name.
seqname
Name of the Oracle Sequence that assigns sequential values.
NEXTVAL
Keyword that inserts the next Oracle value into the destination column.
INCL_UPD
Optional keyword that updates a sequence value assigned to a column when rows are updated during an insert process. If not specified (default), the column value remains unchanged when the row is updated.

Example 1

To assign a sequential value to increment customer numbers, where the name of the Oracle Sequence is schema.numeven, specify:

schema.numeven.NEXTVAL

Example 2

To expand the first example and update an existing sequence value, specify:

schema.numeven.NEXTVAL(INCL_UPD)



Feedback