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