Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Auto-incrementing primary key?
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 Cunningham | DBA | gcunning_at_census.gov U.S. Census Bureau |Received on Wed Jan 14 1998 - 00:00:00 CST