/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 vote199 views1 answer
Oracle current timestamp
SQL
3 votes206 views1 answer
Sql insert inserted id
SQL
1 vote192 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote227 views1 answer
Sql query wordpress export post
SQL
0 vote196 views1 answer
Show database not empty tables postgres
SQL
15 votes210 views6 answers
Laravel db transaction
SQL
1 vote185 views1 answer
Update and replace mysql
SQL
0 vote205 views1 answer
Mariadb current date plus 1 day
SQL
0 vote202 views1 answer
Setval in postgres
SQL
0 vote200 views1 answer
Show mysql account privilleges
SQL