Re: Sequential numbering in Oracle

Thanks for the tip Jim,

Not sure why I didn't think of it myself!

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:8Lnh8.10397$aP6.14029_at_rwcrnsc54...
> Search the newsgroup for sequences or the documentation of sequences.
> Jim
> "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
> >
> >
> >
> >
>
>
Received on Wed Mar 06 2002 - 11:19:03 CST