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

Home -> Community -> Usenet -> c.d.o.server -> Re: Auto-incrementing primary key?

Re: Auto-incrementing primary key?

From: Guus van de Sande <dyntas_at_wxs.nl>
Date: 1998/01/14
Message-ID: <01bd212d$979c74e0$181279c3@pc-guus>#1/1

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

Original text of this message

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