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 vote244 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
2 votes241 views1 answer
How to find table table in stored procedure sql server
SQL
2 votes246 views1 answer
Datetrunc
SQL
0 vote243 views2 answers
How do I install microsoft SQL on my Mac?
SQL
9 votes250 views4 answers
Postgresql export database
SQL
0 vote290 views1 answer
How to rename a database in tsql
SQL
0 vote235 views1 answer
Postgresql create user roles
SQL
-1 vote231 views1 answer
Io
SQL
24 votes199 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
-1 vote232 views1 answer
Window functions in sql
SQL