Let’s say you have a sequence object created called myschema.seq_mysequence which has the next value of 3000 and it normally increments 1 at a time, and let’s say that you need to reserve all numbers between 3000 and 4000 for a special purpose, thus you need to manually advance the sequence from 3000 to 4000. This is how you can increment the sequence 1000:
-- First, alter the object so the next increment will jump 1000 instead of just 1. alter sequence myschema.seq_mysequence increment by 1000; -- Run a select to actually increment it by 1000 select myschema.seq_mysequence.nextval from dual; -- Alter the object back to incrementing only 1 at a time alter sequence myschema.seq_mysequence increment by 1;