/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

0 vote361 views1 answer
Sql where part of string match
SQL
2 votes350 views1 answer
Get hour from date sql
SQL
0 vote359 views1 answer
C# mysql update statement set value to null
SQL
0 vote391 views1 answer
How to install sql in anaconda
SQL
0 vote333 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote391 views1 answer
Psql check if sql script is valid
SQL
24 votes362 views4 answers
Delete db postgres
SQL
0 vote373 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
6 votes382 views3 answers
Mysql remove user privileges
SQL
0 vote313 views3 answers
Mysql calculate age from date of birth
SQL