/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 vote207 views1 answer
Mysql range of dates overlap
SQL
2 votes222 views1 answer
Sql count having
SQL
0 vote202 views1 answer
Postgresql replace html tags from string
SQL
0 vote173 views2 answers
Influxdb delete measurement based on date
SQL
0 vote197 views1 answer
How to put value in parameters in mysqldataadapter
SQL
1 vote264 views1 answer
Sql select contem uma palavra
SQL
1 vote291 views1 answer
Mysql is odd
SQL
0 vote148 views1 answer
'0000-00-00' for column '
SQL
4 votes288 views2 answers
Convert utc to est sql
SQL
4 votes187 views2 answers
Oracle last day of month
SQL