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

  Permalink
• 

  ANURADHA MOHAN March 08, 2017 22:47

  Hi , Oracle 12c.

  0

  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

  Permalink

Please sign in to leave a comment.