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

16 votes344 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote322 views1 answer
Sql select rows with different values in one column
SQL
0 vote337 views1 answer
Python connect to mysql in settings.py
SQL
12 votes328 views2 answers
Delete all entries postgres
SQL
5 votes348 views1 answer
Add column table sql default value
SQL
1 vote312 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote340 views3 answers
How to run sql query
SQL
16 votes325 views2 answers
Add column to all tables after first column mysql
SQL
0 vote349 views1 answer
Cannot pip install mysqlclient
SQL
0 vote345 views1 answer
Oracle swap partition
SQL