How do you recycle a Oracle Sequence Number

Greenhorn

Posts: 2

posted 12 years ago

I need to recycle a Oracle Sequence Number based on a Date.

Client is requesting that at the beginning of every year the sequence number recycle to the min value (0).

Can anyone help. I have no clue how to do this (or if it can even be done).

Thank you!

Chris Hendy

Ranch Hand

Posts: 98

posted 12 years ago

Check out

http://asktom.oracle.com/pls/ask/f?p=4950:8:16425115740643284202::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1119633817597

The glass is neither half full or half empty. It is too big. But this tiny ad is just right:

Enterprise-grade Excel API for Java

https://products.aspose.com/cells/java

How do you recycle a Oracle Sequence Number

Similar Threads