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 vote375 views2 answers
Create temporary table sql
SQL
0 vote385 views1 answer
Basic structure of sql expression having clause
SQL
5 votes351 views1 answer
Mysql change primary key
SQL
5 votes377 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote388 views1 answer
Mysql record group by created date count
SQL
0 vote395 views1 answer
Sql script to remove default from column
SQL
2 votes380 views1 answer
Find all triggers in database
SQL
0 vote358 views2 answers
Nested query
SQL
0 vote428 views1 answer
ALV GRID events
SQL
3 votes370 views2 answers
How to list columns for particular tables in postgresql
SQL