Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Auto-incrementing primary key?
You might consider using Oracle internal ROWID. Nevertheless the Sequence is invented for this purpose.
regards,
Guus van de Sande
Jerry Cunningham <gcunning_at_census.gov> schreef in artikel
<34BD0514.F3E885D0_at_census.gov>...
> A colleague of mine is developing an application that will be accessing
> both an Oracle and a Sybase SQLAnywhere database. The SQLAnywhere
> database has what it calls an "Identifier Field" which is an
> automatically incremented primary key. Does Oracle have anything like
> this?
>
> With Oracle's sequences, you have to explicitly insert the NEXTVAL from
> the sequence, correct? Is there any way that Oracle can automatically do
>
> this? Another DBA told us that she might have heard of something called
> an "auto-increment constraint" (or something like that).
>
> As always, thanks for your help.
>
>
> - Jerry
>
> --
>
> Jerry Cunningham |
> DBA | gcunning_at_census.gov
> U.S. Census Bureau |
>
>
>
Received on Wed Jan 14 1998 - 00:00:00 CST