Thanks Mark!
I am fairly new to all this database and SQL stuff! I will try my best to
decipher all this later!
Thanks again!
"Mark D Powell" <mark.powell_at_eds.com> wrote in message
news:178d2795.0203060738.34efd1a8_at_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 - 11:17:32 CST
