/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

2 votes264 views1 answer
How to delete view in sql
SQL
0 vote312 views1 answer
Calculer pourcentage mysql
SQL
0 vote288 views1 answer
Doctors appointment
SQL
0 vote244 views1 answer
Select password from user mysql
SQL
0 vote261 views1 answer
C# check if mysql query modified rows
SQL
0 vote283 views1 answer
Add mysql database to power bi web
SQL
0 vote284 views1 answer
Oracle swap partition
SQL
0 vote258 views1 answer
Mysql shell set time_zone
SQL
1 vote276 views1 answer
Sql drop schema
SQL
0 vote262 views1 answer
Addition of 2 column value in mysql
SQL