/SQL/Oracle set sequence value to max(id)

Oracle set sequence value to max(id)

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

6 votes390 views3 answers
What is where in sql
SQL
4 votes383 views1 answer
Oracle table statistics
SQL
5 votes353 views2 answers
Functions
SQL
7 votes290 views2 answers
Create mysql user
SQL
1 vote316 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote318 views1 answer
Access mysql database docker container shell
SQL
2 votes305 views1 answer
Oracle index size
SQL
1 vote317 views1 answer
Order by oracle
SQL
2 votes308 views2 answers
How to get capital letter first in sql
SQL
2 votes339 views1 answer
Merge firstname and lastname in sql oracle
SQL