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 -> Re: sequnce as an id

Re: sequnce as an id

From: Grzesiek <grzegorz.gizinski_at_softax.com.pl>
Date: Thu, 18 Mar 1999 23:37:21 GMT
Message-ID: <R6gI2.6970$U1.1161582@news.tpnet.pl>

Ed Zappulla napisał(a) w wiadomości: <7crvun$ls3$1_at_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');
>
>
>

Perhaps you should create BEFORE INSERT TRIGGER on table x which referes to your sequence...

Grzesiek Received on Thu Mar 18 1999 - 17:37:21 CST

Original text of this message

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