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

3 votes145 views2 answers
Search text in all sql server stored procedure
SQL
0 vote151 views1 answer
Start stop mysql linux
SQL
0 vote142 views1 answer
How to input data as id in database sql c#
SQL
0 vote155 views1 answer
Ubuntu connect to mssql database
SQL
0 vote137 views1 answer
Delete ids between sql
SQL
0 vote128 views1 answer
Oracle sql winter time change
SQL
0 vote144 views1 answer
Oracle execute package dblink
SQL
0 vote124 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote168 views1 answer
Compare strings lexicographically in sql
SQL
0 vote158 views1 answer
Postgres row expiration
SQL