Oracle のシーケンスをカウントアップする

SQL> select sequence_name, last_number from user_sequences where sequence_name = 'HOGE_SQ';
 
SEQUENCE_NAME                  LAST_NUMBER
------------------------------ -----------
HOGE_SQ                        100160
 
SQL> drop sequence hoge_sq;
SQL> create sequence hoge_sq increment by 1 start with 200000 nomaxvalue nominvalue nocycle noorder;
SQL> select sequence_name, last_number from user_sequences where sequence_name = 'HOGE_SQ';
 
SEQUENCE_NAME                  LAST_NUMBER
------------------------------ -----------
HOGE_SQ                        200000