Default value from sequence

                                             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 - 05:02:37 CDT