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

2 votes203 views2 answers
Sqlalchemy return id after insert
SQL
21 votes174 views6 answers
Docker run mysql
SQL
7 votes184 views6 answers
Reset identity column in sql server
SQL
1 vote185 views4 answers
Sequelize migration default value
SQL
1 vote213 views1 answer
Insert many to many sql
SQL
19 votes174 views6 answers
What is mySQL
SQL
2 votes200 views1 answer
Install postgresql centos 5
SQL
0 vote186 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote136 views1 answer
Mysql offset from bottom
SQL
1 vote193 views1 answer
Top 10 rows in mysql
SQL