Re: Sequential numbering in Oracle

"trub3101" <michael_at_bassline01.fsnet.co.uk> wrote in message news:<a64rj4$re3$2_at_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

There is an article on this topic at the co-operative FAQ which you might find of interest:
How do you create an 'auto number' or 'auto increment' column similar to the offering from Microsoft's SQL Server ? http://www.jlcomp.demon.co.uk/faq/autonumb.html

HTH
-- Mark D Powell -- Received on Wed Mar 06 2002 - 09:38:20 CST