Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Using SYSDATE as part of Primary Key?
A couple of analysts were having a discussion the other day with respect
to using SYSDATE as part of the primary key (actually a column in the
table would be defined as ENTERED_DATE with a default value of
SYSDATE). The discussion centered around the possibilty of 2 users
entering the same data at the same time and thusly one of them getting
an error about a duplicate record. I would think that entering 2
records with the same key (if SYSDATE was part of the key) at the same
time would be almost impossible to do, but does anyone else know if
Oracle's SYSDATE would have problems doing this?
Douglas Scott
Douglas.S.Scott_at_USAHQ.unitedspacealliance.com
Received on Wed Feb 24 1999 - 07:43:32 CST