Sequential numbering in Oracle

From: trub3101 <michael_at_bassline01.fsnet.co.uk>
Date: Wed, 6 Mar 2002 10:08:38 -0000
Message-ID: <a64rj4$re3$2@newsg2.svr.pol.co.uk>

Hi everyone,

I have just migrated a MS Access database to Oracle 8i by exporting it to a flat comma-seperated file and using SQL*Loader populate the Oracle database.

After much tinkering during populating the Oracle database I now seem to have lost the functionality of the primary key (ref) which in Access automatically generated the next number for the next record appended to the database.

Could anyone just clarify for me whether or not Oracle provides this functionality?
I suspect that it does not, not sure why?

Will I have to write some sort of procedure or routine that does this?

My first inkling is to create a Java singleton class that generates consecutive numbers when access and link it to the primary key of the table. Am I mad?

Thanks (in advance)

tb3101 Received on Wed Mar 06 2002 - 04:08:38 CST