jump the sequence
555356Sep 10 2007 — edited Sep 11 2007I have a sequence like this:
SQL> select sequence_name,min_value,max_value,increment_by,last_number from user_sequences where sequence_name='ORDER_SEQUENCE';
SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY LAST_NUMBER
------------------------------ ---------- ---------- ------------ ----------------------------------------------------------------------
ORDER_SEQUENCE 1010001 1.0000E+27 1 4430701
I want to jump the sequence number from 7 digit to 8 digit by changing the last_number from 4430701 to 10000000. How can I do that?