Sequence Next Value as a default value
I want to assign default value to a column from a nextval of a sequence object. Could you please Guide.
-
According to online Oracle 12c documents:
2.1.6.1 Default Values for Columns Based on Oracle Sequences
Default values for columns can directly refer to Oracle sequences. Valid entries are sequence.CURVAL and sequence.NEXTVAL.
Providing the functionality to directly refer to a sequence as a default value expression simplifies code development.
Please sign in to leave a comment.
Comments
3 comments