Oracle reset sequence

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 vote188 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote196 views1 answer
How to update sql server version
SQL
3 votes137 views1 answer
How to get list of synonyms in oracle
SQL
0 vote220 views1 answer
Testing sql queries
SQL
0 vote156 views1 answer
Prevent duplicate rows in postgres
SQL
5 votes214 views1 answer
Oracle create table comment
SQL
1 vote188 views1 answer
Mariadb get column names from table
SQL
1 vote200 views3 answers
Update from select sqlite
SQL
0 vote193 views4 answers
How to connect form to database
SQL
0 vote211 views1 answer
How to change mysql port in xampp
SQL