Database Administration (MOSC)

MOSC Banner

sequence that gets reset back to zero at the start of the year

edited May 13, 2014 11:17AM in Database Administration (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center