/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 vote286 views1 answer
Sql contains vs like
SQL
0 vote278 views1 answer
Get only structure database mysql
SQL
0 vote281 views1 answer
Sql server manager close connection
SQL
1 vote293 views1 answer
Sql server 2012 query history
SQL
0 vote312 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote292 views1 answer
Create database like
SQL
0 vote303 views1 answer
Mysql 8 geo to json
SQL
45 votes354 views5 answers
Grant all privileges mysql
SQL
1 vote301 views1 answer
Postgres power
SQL
1 vote288 views1 answer
Postgresql reset serial counter after deleting content
SQL