Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NEXTVAL in CREATE TABLE ?
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