Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reset a Sequence
I posted a solution to this on the 26th of March, you'll find it on Google
"Roman Sochan" <rsochan_at_removeme.ix.netcom.com> wrote in message
news:9mm156$8u4$1_at_slb0.atl.mindspring.net...
> Is there a way to have Oracle automatically reset a sequence on a schedule
> every morning?
>
> The database in question will use a primary key which includes the
sequence
> and a date:
>
> 0001-30AUG2001
> 0002-30AUG2001
> 0003-30AUG2001
> .
> .
> the next day:
>
> 0001-31AUG2001
> 0002-31AUG2001
>
>
Received on Mon Sep 03 2001 - 08:28:38 CDT