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 -> CREATING SEQUENCES - HELP PLEASE

CREATING SEQUENCES - HELP PLEASE

From: Javier Riera <javier_at_bitel.es>
Date: 1997/10/20
Message-ID: <344B2AC6.47A5@bitel.es>#1/1

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 Mon Oct 20 1997 - 00:00:00 CDT

Original text of this message

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