/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 vote335 views1 answer
How to get specific salary in sql
SQL
1 vote327 views1 answer
Sysdate in sql
SQL
3 votes395 views1 answer
Mysql cli connect with password
SQL
1 vote321 views1 answer
Mysql query bulk insert
SQL
0 vote340 views1 answer
Laravel migration sql dump
SQL
1 vote324 views1 answer
Postgres convert date to string
SQL
0 vote328 views1 answer
Mysql query to add hours to column in table
SQL
5 votes387 views3 answers
Create function in postgresql
SQL
1 vote328 views1 answer
Mysql current time
SQL
0 vote346 views1 answer
SQL Server date literal
SQL