Change LAST_NUMBER value in a sequence (NEXTVAL)
Change increment by, select next value, set increment back to original value:

SQL&gt; create sequence s1 start with 5;

Sequence created.

SQL&gt; select last_number from user_sequences where sequence_name = 'S1';

LAST_NUMBER
-----------
          5

SQL&gt; alter sequence s1 increment by 57;

Sequence altered.

SQL&gt; select s1.nextval from dual;

   NEXTVAL
----------
        61

SQL&gt; alter sequence s1 increment by 1;

Sequence altered.

SQL&gt; select last_number from user_sequences where sequence_name = 'S1';

LAST_NUMBER
-----------
         62


Or use RESTART:

SQL&gt; alter sequence s1 restart start with 77;

Sequence altered.

SQL&gt; select last_number from user_sequences where sequence_name = 'S1';

LAST_NUMBER
-----------
         77