/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 vote151 views2 answers
Import data from excel to sql server automatically
SQL
0 vote146 views1 answer
Sql remove last 2 digit
SQL
0 vote151 views1 answer
Mysql join column order By and group By
SQL
51 votes244 views6 answers
Opera gx
SQL
2 votes138 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
3 votes132 views1 answer
Uppercase and lowercase in sql
SQL
0 vote133 views1 answer
Mysql calculated column
SQL
0 vote144 views1 answer
Remove mysql from centos 7
SQL
1 vote160 views1 answer
How to delay stored procedure execution in sql server
SQL
2 votes133 views1 answer
Postgresql update sequence next value
SQL