How do you recycle a Oracle Sequence Number

Greenhorn

Posts: 2

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Check out

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

I carry this gun in case a vending machine doesn't give me my fritos. This gun and this tiny ad:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders