/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 vote249 views1 answer
Uncheck constraints and delete from table
SQL
0 vote262 views1 answer
SQL check if record exist
SQL
7 votes240 views1 answer
Xampp reset mysql
SQL
0 vote224 views2 answers
Azure sql-datenbank
SQL
1 vote268 views1 answer
Mysql view curren querys
SQL
0 vote260 views2 answers
Compound operator in sql
SQL
0 vote240 views1 answer
Mysql create pool
SQL
0 vote222 views1 answer
Login phpmyadmin without password
SQL
-1 vote252 views4 answers
Sql view postgresql
SQL
0 vote227 views1 answer
Sql select most frequent value in group
SQL