/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 vote331 views1 answer
Sql case sttement with set
SQL
3 votes342 views2 answers
Install mysql powershell
SQL
1 vote353 views2 answers
Extract weekday from date in sql
SQL
0 vote361 views1 answer
Postgresql list extensions
SQL
0 vote324 views1 answer
Display first three characters sql
SQL
3 votes314 views2 answers
Coalesce mysql
SQL
3 votes316 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote361 views1 answer
Querry mysql by 2 columns
SQL
4 votes326 views4 answers
Update select mysql
SQL
4 votes334 views2 answers
How to insert ip address in mysql using php
SQL