/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

1 vote338 views1 answer
Oracle sql listagg
SQL
0 vote298 views1 answer
Java spring boot connect to sql server
SQL
0 vote342 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote348 views1 answer
Sql on-premises
SQL
0 vote381 views2 answers
Disallowed function mysql to_date()
SQL
5 votes328 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote328 views1 answer
Left join in codeigniter query builder
SQL
0 vote349 views1 answer
Install mysql for fedora 34
SQL
2 votes355 views2 answers
Postgres trigger insert into another table
SQL
6 votes388 views2 answers
How to get last element sql
SQL