Re: NEXTVAL in CREATE TABLE ?

Use it in BEFORE INSERT Trigger :

select seq.nextval into :new.FIELD from dual;

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

--
Best Regards,          ||       Ñ óâàæåíèåì,
        Oleg Dmitriev,    ||            Îëåã Äìèòðèåâ,