Sequence Next Value as a default value

Follow

ANURADHA MOHAN

January 17, 2017 00:11

I want to assign default value to a column from a nextval of a sequence object. Could you please Guide.

-1

• 

  Bill Bunke March 08, 2017 14:44

  What DB version is the target (10 / 11 / 12 / ??)

  0

  Comment actions Permalink
• 

  ANURADHA MOHAN March 08, 2017 22:47

  Hi , Oracle 12c.

  0

  Comment actions Permalink
• 

  Bill Bunke March 09, 2017 16:27

  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.

  0

  Comment actions Permalink

Please sign in to leave a comment.