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

Home -> Community -> Usenet -> c.d.o.misc -> Re: CREATING SEQUENCES - HELP PLEASE

Re: CREATING SEQUENCES - HELP PLEASE

From: Anil Kumar <anilknair_at_hotmail.com>
Date: 1997/10/24
Message-ID: <62q8tc$lg6$1@srv2.sj.ablecom.net>#1/1

Is it possible to add sequence object to table identifier, it is not possible to add.
If possible , pls let me know anilknair_at_hotmail.com Thanks
Anil
Javier Riera wrote in message <344B2AC6.47A5_at_bitel.es>...
>I am trying to build a table where the identifier must autocalculates
>its own value. Has the sequence object this property?
>I created a secuence as:
>
>CREATE SEQUENCE miSeq
> INCREMENT BY 1
> START WITH 0
> MINVALUE 0
> MAXVALUE 9999999
> NOCYCLE
> CACHE 20
> NOORDER
>;
>
>How can I assign this sequence to my table's identifier?
>
>Thanks.
Received on Fri Oct 24 1997 - 00:00:00 CDT

Original text of this message

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