Updating a Sequence

[jmodic]

Let's say your sequence is currently at value 101, you wan't it to skip immediately to value 1001 and then retrive values from there on. One of the methods is:

alter sequence my_seq increment by 900;
select my_seq.nextval from dual:
alter sequence my_seq increment by 1;