Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Autonumber Field in Oracle
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
![]() |
![]() |