Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Default value from sequence
You'll have to use a trigger on xyz table inserts.
Erkki Arus wrote in message <7np8pf$dsu$1_at_keeks.cyber.ee>...
> Hi,
>
>I'm a simple question: i have a table xyz where is column ID and it is
>primary key. How i can set default value from sequence MYSEQ for this
>column? The line in "ID NUMBER DEFAULT myseq.nextval" in CREATE TABLE or
>ALTER TABLE statement is not allowed.
>
>Thanks.
>
>Erkki Arus
>e-mail: aphex_at_spin.ee
>http://hobbit.spin.ee/~aphex/
>
Received on Thu Jul 29 1999 - 06:26:07 CDT