Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reset Sequence

560669Feb 8 2010 — edited Feb 9 2010
Hi

I have a sequence, i need to reset the sequence in the beging of every year.

example

as of date the current value of the sequence is 8976

and at the begin of the year 2011 the sequence should start with 1

Pls let me know how to achieve this.

Regards
Yram
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2010
Added on Feb 8 2010
5 comments
868 views