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 vote205 views2 answers
Mysql show foreign keys
SQL
0 vote170 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote163 views1 answer
Search In the Database using Text
SQL
0 vote177 views1 answer
Flask sqlalchemy decimal
SQL
1 vote204 views1 answer
Ubuntu access database from terminal
SQL
2 votes178 views1 answer
How to get weekday from old date in sql
SQL
0 vote174 views1 answer
Mysql query problems and solutions
SQL
2 votes216 views1 answer
Username sql
SQL
7 votes164 views1 answer
Sql server convert string to date
SQL
1 vote161 views1 answer
Sql Split string function
SQL