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 vote270 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
2 votes242 views1 answer
Date_format for time sql
SQL
3 votes254 views2 answers
Laravel tosql with bindings
SQL
3 votes259 views1 answer
Dbms_scheduler drop_job
SQL
0 vote259 views1 answer
Php get closest location by latitude longitude
SQL
3 votes303 views1 answer
What is having
SQL
7 votes249 views4 answers
Mysql delete older duplicates
SQL
1 vote264 views1 answer
Oracle drop chain step
SQL
1 vote250 views2 answers
End mysql command
SQL
0 vote245 views1 answer
How much table store postgres
SQL