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 vote195 views1 answer
Mysql where in keep order
SQL
2 votes193 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
6 votes341 views1 answer
Sql insert values into table
SQL
0 vote214 views1 answer
Sql select min row
SQL
0 vote191 views1 answer
Mariadb search columns
SQL
0 vote189 views1 answer
Postgres enumerated type
SQL
4 votes212 views2 answers
Oracle unlock account
SQL
3 votes197 views1 answer
Show index table
SQL
45 votes279 views5 answers
Grant all privileges mysql
SQL
0 vote255 views1 answer
How to find top 3 salary in sql
SQL