Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Reset a Sequence
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 Thu Aug 30 2001 - 13:33:44 CDT