/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 vote197 views1 answer
Nth max in my sql
SQL
0 vote212 views1 answer
Python dictionary to sql update
SQL
0 vote237 views1 answer
Sql query interview questions githu
SQL
0 vote209 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote241 views1 answer
How to check oracle index table
SQL
1 vote201 views1 answer
Oracle sql average
SQL
0 vote227 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
7 votes206 views1 answer
Mysql iif
SQL
0 vote311 views1 answer
Mysql multiple group by
SQL
0 vote226 views2 answers
Impala rename column name
SQL