Re: time based sequence/trigger

From: FaheemRao <faheemrao_at_yahoo.com>
Date: 10 Oct 2001 16:55:25 -0700
Message-ID: <43b58913.0110101555.4addf490@posting.google.com>

you can do this

try to use the Oracle Sequence Object and at the end of the day you have to drop that sequence Object and then recreacte that so to reset the next value.

"John Dunn" <JLDunn_at_ukgateway.net> wrote in message news:<3bc499e6$0$230$cc9e4d1f_at_news.dial.pipex.com>...
> I have a column in a table. I want the value to increment automatically each
> time a record is created. But I would also like the value to reset to 1 when
> the first record of the day is written, i.e the first record after midnight.
>
> Is there anyway to do this?
>
> John
Received on Wed Oct 10 2001 - 18:55:25 CDT