Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Risk in using sequence number?
In 9i, you could insert SYSTIMESTAMP which gives much better
granularity than SYSDATE.
I have always been happy to use sequence numbers to ensure uniqueness and to guarantee that later values are higher than earlier ones. Although I usually assign a bunch of sequence values all at once rather than spread out over time. (SQL*Loader can assign sequence values to a column as it loads a set of rows, which I find cleaner than assigning the sequence values via UPDATE and doing an ALTER TABLE to change that column to the primary key.)
John
On Thu, 21 Feb 2002 22:56:48 -0000, "Keith Boulton" <kboulton_at_ntlworld.com> wrote:
>I would argue (it is my nature) that 1/100 second is not enough.
>
>damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message
>news:3C756B35.2FFC9D6C_at_ci.seattle.wa.us...
>> You can also use DBMS_UTILITY.GET_TIME() to return 1/100ths of a second
>for
>> more granularity.
-- Got an Oracle database question? Try the search engine for the database docs at: http://tahiti.oracle.com/Received on Fri Feb 22 2002 - 04:26:48 CST