sp_sequence_get_range equivalent in Oracle Do we have sp_sequence_get_range equivalent in Oracle.

I need to advance my sequence by some numbers always how can I achieve this.
Just alter then increment the sequence. 

For example, to increment by 1000:

ALTER SEQUENCE yoursequence INCREMENT BY 1000;


You then have to SELECT the NEXTVAL from the sequence and re-alter it to increment by the usual value to restore "normal" operation.

To check the current value without incrementing:

SELECT yoursequence.CURRVAL FROM DUAL;


If you need to decrease the sequence, just ALTER SEQUENCE by a negative amount (very intuitive!).