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

0 vote170 views1 answer
How to install Firebird
SQL
0 vote188 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote199 views1 answer
Add mysql database to power bi web
SQL
2 votes184 views1 answer
Oracle run_duration average
SQL
0 vote178 views1 answer
Sql not exists
SQL
4 votes183 views2 answers
Oracle unlock user
SQL
0 vote176 views1 answer
Drop index in sql
SQL
-1 vote177 views1 answer
Sql select data from one database and insert into a different database
SQL
1 vote182 views2 answers
Mysql trim spaces
SQL
0 vote235 views1 answer
Hierarchal database table
SQL