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

10 votes169 views5 answers
Mysql create user
SQL
13 votes237 views6 answers
Mysql remove duplicates
SQL
5 votes199 views2 answers
Postgresql add not null constraint
SQL
6 votes230 views2 answers
WHERE value IS sql
SQL
0 vote202 views2 answers
Sql query print strings and int
SQL
0 vote190 views1 answer
How to change mysql root password in windows 10
SQL
1 vote178 views1 answer
Sql eliminare un record
SQL
3 votes222 views1 answer
Export postgres database linux
SQL
4 votes195 views1 answer
For loop postgresql
SQL
0 vote195 views1 answer
What logs are available on RDS MySQL?
SQL