/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

15 votes146 views4 answers
Mysql where value is null
SQL
9 votes161 views6 answers
Check constraint in sql
SQL
8 votes136 views1 answer
How to remove tables from postgresql
SQL
0 vote165 views1 answer
Create query in where clasue
SQL
0 vote178 views1 answer
Login failed for user sql server
SQL
-1 vote156 views1 answer
Phinehas Psalm 106
SQL
5 votes136 views1 answer
Ora-00054 find lock
SQL
0 vote146 views1 answer
Sql case when exists in another table
SQL
2 votes174 views2 answers
Mysql does sentence contain word
SQL
7 votes144 views3 answers
Sql get last inserted row
SQL