/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 vote309 views1 answer
Tsql delete all rows
SQL
0 vote349 views1 answer
Sql query to select even numbers
SQL
0 vote340 views1 answer
Find and replace query in wordpress\
SQL
0 vote292 views1 answer
Sql column as header
SQL
0 vote299 views1 answer
Mysql match in serialized data
SQL
16 votes304 views4 answers
Ascending order mysql
SQL
1 vote287 views2 answers
Mysql join two tables
SQL
1 vote293 views3 answers
Reset sql primary key
SQL
2 votes295 views2 answers
Mysql limit
SQL
2 votes327 views2 answers
Sql lag
SQL