Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sequnce as an id

sequnce as an id

From: Ed Zappulla <zappullae_at_rcn.com>
Date: Thu, 18 Mar 1999 17:51:40 -0500
Message-ID: <7crvun$ls3$1@winter.news.rcn.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US