unique ID

Giganews Newsgroups
Subject: unique ID
Posted by:  Christoph Kukulies (ku…@accms33.physik.rwth-aachen.de)
Date: 8 Dec 2004

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

Replies