alter sequence test increment by 100;
select test.nextval from dual;
alter sequence test increment by -100;
select test.nextval from dual;
Through resetting increment number, sequence can be reset to what number you want for next value.
reference:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1119633817597
http://docs.oracle.com/cd/E14072_01/server.112/e10592/statements_2012.htm
No comments:
Post a Comment