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 vote194 views1 answer
Mysql uuid
SQL
0 vote333 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote249 views2 answers
Mysql limit offset
SQL
0 vote202 views1 answer
Mariadb select limit offset
SQL
0 vote204 views1 answer
Postgres can integer fields be negative
SQL
4 votes190 views1 answer
Oracle session date format
SQL
0 vote200 views1 answer
Mysql procedure between two tables
SQL
5 votes269 views1 answer
Purge undo tablespace oracle 11g
SQL
2 votes226 views1 answer
Oracle log files
SQL
0 vote203 views1 answer
Every Derived yable must have its own alias
SQL