Re: Indexed Organized Tables

what version of Oracle, as the type TIMESTAMP should have a much finer resolution than one second, not that centiseconds or milliseconds would eliminate the race condition anyways.

use a sequence to generate a numeric unique identifier and add that column to the primary key - populate in the insert trigger if the sequence.nextval is not included in the insert statement. hth.

-bdbafh Received on Mon Jan 10 2005 - 13:04:20 CST