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 -> Re: NEXTVAL in CREATE TABLE ?

Re: NEXTVAL in CREATE TABLE ?

From: BobH <b-horton_at_worldnet.att.net>
Date: 1998/04/06
Message-ID: <6gc2fv$q5n@bgtnsc02.worldnet.att.net>#1/1

Mark wrote:
>
> What is the exact syntax to use NEXTVAL in a column in a CREATE TABLE
> statement ?
>
> I've tried DEFAULT NEXTVAL, and DEFAULT MY_ID.NEXTVAL, but neither seem to
> work.
>
> Mark

you can't use NEXTVAL as a DEFAULT in a Create Table or ALTER TABLE. What are you trying to do? Received on Mon Apr 06 1998 - 00:00:00 CDT

Original text of this message

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