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 vote123 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote112 views1 answer
Replace multiple string in query sql
SQL
0 vote109 views1 answer
Mysql show category once count how many products
SQL
0 vote103 views1 answer
Mysql error 1452
SQL
0 vote157 views1 answer
Jpa generationtype sequence mysql
SQL
24 votes118 views4 answers
Postgres delete database
SQL
1 vote121 views3 answers
Reset sql primary key
SQL
0 vote150 views1 answer
How to get table id sequence postgres
SQL
2 votes113 views1 answer
When matched in sql server
SQL
10 votes130 views2 answers
What is database
SQL