Updating a Sequence

I am to alter the next value in a sequence i have however i am unsure of the syntax and could not find something i could understand in pasts posts.


When I do select * from all_sequences i see we have a LAST_NUMBER field. How can I adjust this to a new number above this.


Thanks

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:

Code:

---

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

---