Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> CREATING SEQUENCES - HELP PLEASE
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
![]() |
![]() |