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 vote342 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote339 views1 answer
Changing name of column and datatype in sql
SQL
0 vote329 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote416 views1 answer
Oracle simple quote
SQL
0 vote343 views1 answer
DATEDIFF minute postgres
SQL
7 votes323 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote339 views1 answer
Reona
SQL
-1 vote407 views5 answers
Left join sql
SQL
1 vote333 views1 answer
Mysql dump specific tables
SQL
0 vote334 views1 answer
Sql select most frequent value in column
SQL