/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

3 votes337 views2 answers
How to View column names of a table in SQL
SQL
2 votes320 views1 answer
Mysql list users on ubuntu
SQL
0 vote335 views1 answer
Get number of tables in database sql
SQL
3 votes403 views2 answers
Savepoint in sql
SQL
0 vote366 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote341 views1 answer
Varchar format not case sensitive sql
SQL
2 votes340 views1 answer
Oracle find unusable indexes
SQL
0 vote405 views1 answer
Mysl like insert a variable
SQL
3 votes334 views1 answer
Oracle wait
SQL
0 vote342 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL