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 -> Re: Sequential numbering in Oracle

Re: Sequential numbering in Oracle

From: Mark D Powell <mark.powell_at_eds.com>
Date: 6 Mar 2002 07:38:20 -0800
Message-ID: <178d2795.0203060738.34efd1a8@posting.google.com>


"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

Original text of this message

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