1SELECT LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = 'seq_name';
2
3ALTER SEQUENCE seq_name INCREMENT BY 100; -- Value to reach desired value - 1
4SELECT seq_name.nextval FROM dual; -- Reinitialize value to desired
5ALTER SEQUENCE seq_name INCREMENT BY 1; -- Back to init step
1SELECT schema.seq_name.NEXTVAL FROM dual;
2
3INSERT INTO table_name (VALUE1) VALUES (
4 schema.seq_name.NEXTVAL AS VALUE1
5);