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

4 votes110 views4 answers
Oracle tablespace tables list
SQL
2 votes129 views1 answer
Show max_allowed_packet mysql
SQL
3 votes115 views1 answer
Pl sql escape &
SQL
0 vote127 views1 answer
Update database collation in postgresql
SQL
-1 vote117 views8 answers
Sql to c# linq converter online
SQL
0 vote115 views1 answer
Mysql update from n to 100
SQL
1 vote103 views2 answers
Oracle difference between two dates in seconds
SQL
2 votes108 views1 answer
Set boolean flasksql
SQL
0 vote105 views1 answer
Get yesterday date ISO in psql
SQL
7 votes119 views2 answers
How to create index mysql
SQL