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

8 votes215 views2 answers
Safe update mode in mysql
SQL
0 vote202 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote239 views1 answer
Create email address from first and last name in sql
SQL
0 vote214 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote202 views1 answer
Mysql repair a table
SQL
3 votes201 views1 answer
Mssql remove column
SQL
0 vote211 views1 answer
Sql server sleep
SQL
0 vote205 views1 answer
Install sql server windows 10
SQL
0 vote262 views1 answer
Reindexing all tables sql server
SQL
22 votes228 views4 answers
Date format mysql
SQL