Re: oracle sequence numbers

From: Pablo Sanchez <pablo_at_dev.null>
Date: Thu, 16 Jan 2003 09:40:02 -0600
Message-ID: <Xns9305582AF8905pingottpingottbah@216.166.71.233>

pbrazier_at_cosmos-uk.co.uk (Paul) wrote in news:51d64140.0301160117.33bd67de_at_posting.google.com:

> rhairgroveNoSpam_at_Pleasebigfoot.com (Bob Hairgrove) wrote in message
> news:<3e25b10b.5066735_at_news.webshuttle.ch>...

>> You can also use a timestamp instead of a sequence ... at least this
>> has the advantage of letting you know when the data was inserted.

>
> if you ever add more than one row at a time this wouldn't be unique
> though.

Even worst, some DBMS update the timestamp any time the row is affected since the timestamp data type is used for other purposes.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Thu Jan 16 2003 - 09:40:02 CST