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

Home -> Community -> Usenet -> c.d.o.misc -> Autonumber Field in Oracle

Autonumber Field in Oracle

From: Chris Capson <capsoncc_at_nbnet.nb.ca>
Date: Mon, 1 Feb 1999 20:41:18 -0400
Message-ID: <795h63$i56$1@garnet.nbnet.nb.ca>


I am currently migrating a Microsft Access 97 application to Oracle. I have created all of my tables but i can't figure out how to handle the autonumber field from Microsoft access. This autonumber field should automatically increment by one anytime anybody inserts a record into the table. I have been reading about it and it sounds like Oracle has some sort of CREATE SEQUENTIAL. I am note sure how to set it up so that anytime a record is added that the primary key field will be incremented automatically. If anybody has any recommendations or examples they would be greatly appreciated.

Thanks
Chris Capson Received on Mon Feb 01 1999 - 18:41:18 CST

Original text of this message

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