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

2 votes353 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote311 views2 answers
Sql select inside select
SQL
0 vote372 views1 answer
Sqlite unique multiple columns
SQL
0 vote351 views1 answer
Grant privileges of databse to user
SQL
0 vote364 views1 answer
Mysql query with sql to get the next row
SQL
2 votes359 views1 answer
Use cases condition in sql query laravel
SQL
1 vote363 views5 answers
What is in operator in sql
SQL
0 vote350 views1 answer
How change the field place in mysql
SQL
15 votes334 views2 answers
Open postgress in terminal mac
SQL
0 vote345 views1 answer
How to change null display in psql
SQL