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!

SQL Statement to reset a sequence at every period change

514497Jan 3 2008 — edited Jan 4 2008

Hi All,

We have a requirement to reset a counter/sequence at the start of each period. That is if the counter has value "3" in Dec-07 period, when the Jan-08 period is open it should reset back to "0". Is this possible?

Thanks,
Prathibha

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2008

Added on Jan 3 2008

13 comments

1,345 views