Re: oracle sequence numbers
From: Pablo Sanchez <pablo_at_dev.null>
Date: Thu, 16 Jan 2003 09:40:02 -0600
Message-ID: <Xns9305582AF8905pingottpingottbah_at_216.166.71.233>
>
> if you ever add more than one row at a time this wouldn't be unique
> though.
Date: Thu, 16 Jan 2003 09:40:02 -0600
Message-ID: <Xns9305582AF8905pingottpingottbah_at_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.
-- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.comReceived on Thu Jan 16 2003 - 16:40:02 CET