Re: Automatic Numbers with Sequence

In article <43b8ub$7mk_at_ns.access.ch>, <integrata_at_access.ch> writes:
> Path:

noc.tor.hookup.net!hookup!usenet.eel.ufl.edu!newsfeed.internetmci.com!howland.r eston.ans.net!EU.net!Germany.EU.net!news.dfn.de!scsing.switch.ch!ns.access.ch!i ntegrata
> From: integrata_at_access.ch (INTEGRATA AG)
> Newsgroups: comp.databases.oracle
> Subject: Automatic Numbers with Sequence
> Date: 15 Sep 1995 07:11:07 GMT
> Organization: INTEGRATA AG
> Lines: 9
> Message-ID: <43b8ub$7mk_at_ns.access.ch>
> NNTP-Posting-Host: integrata.access.ch
> X-Newsreader: News Xpress Version 1.0 Beta #3
>
> Hi there,
> i am looking for a nice way to implement automatic numbering (keys)
> within an oracle database.
> all i could find up to now, is using a sequence and a trigger,
> that always selects the next key from a dummy table before an insert.
> is this the only (and/or) best way to do it ????
>
> Hauke
>

Yes, this is the best way because Oracle will coordinate the conflicts when more then one request is made for the next sequential number.

\lfeges Received on Mon Nov 06 1995 - 00:00:00 CET