/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 vote235 views1 answer
Mql5 datetime get hour
SQL
1 vote152 views1 answer
Unique vs distinct sql
SQL
0 vote168 views1 answer
Sql cross apply vs join
SQL
0 vote179 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
4 votes184 views1 answer
To date oracle with time
SQL
0 vote212 views1 answer
Repeatable read trong sql server
SQL
1 vote199 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
1 vote218 views2 answers
Install sql server management studio ubuntu
SQL
0 vote178 views2 answers
How to get json data mysql
SQL
1 vote175 views1 answer
Import local sql into remote mysql
SQL