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!

Sequence nextval reset at every month with 1

AhmedJan 9 2010 — edited Jan 11 2010
I want to change Sequence Nextval = 1 at every month

I m using this sequence 
create sequence VoucherNo
minvalue 1
maxvalue 9999999
start with 1
increment by 1
Order;
i want then when start next month sequence nextval should be 1 .
reset with 1.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2010
Added on Jan 9 2010
8 comments
3,120 views