Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to assign a sequence value as a default for a column

How to assign a sequence value as a default for a column

From: Vernon Adams <vernon_at_ezgov.com>
Date: Tue, 13 Jul 1999 16:45:36 -0400
Message-ID: <378BA570.136E1924@ezgov.com> 





I want to use a sequence to generate unique ids  for records.  I would
like to setup the table such that the default value for the id column is
the nextval from the sequence.  I cannot seem to convince Oracle to do
that.



Does anyone know how I can accomplish this?



Thanks,


Vernon Adams



Received on Tue Jul 13 1999 - 15:45:36 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US