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

6 votes247 views2 answers
Psql load dump
SQL
0 vote238 views1 answer
Like date sql server not working
SQL
3 votes364 views6 answers
Sql unique select
SQL
0 vote177 views1 answer
Check if has alpha characters sql
SQL
0 vote220 views1 answer
Including parameters in OPENQUERY
SQL
-1 vote232 views1 answer
Capitole toulouse
SQL
0 vote254 views1 answer
Stored procedure function relation
SQL
0 vote251 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
12 votes211 views5 answers
Sql primary key
SQL
0 vote225 views2 answers
Plsql function that return a table
SQL