Re: unique ID

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Wed, 08 Dec 2004 11:18:35 GMT
Message-ID: <fqBtd.64195$K7.11162@news-server.bigpond.net.au>

Christoph,

Why not consider sequences? Refer to the Oracle 9.2 Concepts Guide, "The Sequence Generator" on p.10-25 onwards.

Douglas Hawthorne

"Christoph Kukulies" <kuku_at_accms33.physik.rwth-aachen.de> wrote in message news:31o3aiF3aqposU1_at_news.dfncis.de...
> When inserting items into a table (chunks of LONGs) that come in
> from a transaction I need some unique ID that can accompany the item
> so that it can be identified uniquely even if the contents is the
> same (e.g. the user of the alien transaction system hits the submit button
> twice or over and over again). Also sorting the list by timestamp
> would be desirable. I thought of so to say conglamer the date/timestamp
> with
> a random number to ibtain a unique ID that allows for sorting by date
> at the same time.
>
> Are there already provisions for that in Oracle or in databases per se?
>
> --
> Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
>
Received on Wed Dec 08 2004 - 05:18:35 CST