sequence that gets reset back to zero at the start of the year
Hello
the app team needs to have a sequence that is set back to zero at the beginning of the year. I'm pretty sure that there is no straightforward way to do that. I can see the following options
- drop and recreate the sequence at the beginning of the year
- create a sequence with cycle set to yes and have the app team to alter the sequence to its maxvalue at the end of the year so that the next year the sequence will start with zero
Are there any other options that people use?
thank you
Gene