Re: unique ID

Giganews Newsgroups
Subject: Re: unique ID
Posted by:  Jim Kennedy (
Date: Wed, 08 Dec 2004

"Christoph Kukulies" <ku…> wrote in message
> 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
> 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)
Use sequences.  Random numbers don't mean the numbers don't or won't repeat.



In response to

unique ID posted by Christoph Kukulies on 8 Dec 2004