Set sequence value oracle

SELECT LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = 'seq_name';

ALTER SEQUENCE seq_name INCREMENT BY 100;	-- Value to reach desired value - 1
SELECT seq_name.nextval FROM dual;			-- Reinitialize value to desired
ALTER SEQUENCE seq_name INCREMENT BY 1;		-- Back to init step

Similar codes

1 vote114 views2 answers
Sql multiline comment
SQL
0 vote101 views1 answer
Sql server check whether column has same equal values
SQL
0 vote102 views1 answer
Power bi dax add related shows column but not working
SQL
5 votes95 views2 answers
Oracle list columns schema
SQL
0 vote107 views1 answer
Mysql row generator
SQL
0 vote99 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote102 views1 answer
Oracle query archive mode
SQL
1 vote112 views2 answers
Sql server concat string and int
SQL
0 vote98 views1 answer
Install mysql for fedora 34
SQL
0 vote114 views1 answer
Alter rename command in mysql
SQL