Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sequnce as an id
Does anyone know how to specifiy a sequence as a default value for a primary
key id? I want to do an auto number without having to explicitly set the
value for each insert. ie:
create sequence seq_id;
create table x
(
id number default x.nextval not null, ---- bad syntax. how to do this?
name varchar2(255) not null
);
insert into x (name) values ('xxxx'); Received on Thu Mar 18 1999 - 16:51:40 CST