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

0 vote267 views1 answer
Postgres in operator with comma separated values
SQL
0 vote281 views1 answer
Get a list of tables and the primary key
SQL
1 vote279 views1 answer
Rows to comma separated values in mssql
SQL
3 votes230 views1 answer
How to get list of synonyms in oracle
SQL
1 vote279 views2 answers
Regex starts with
SQL
7 votes274 views3 answers
Select latest entry in sql table
SQL
0 vote305 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote269 views1 answer
Sql value exists in column
SQL
3 votes270 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote313 views1 answer
Mysql convert charset
SQL