/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 vote177 views1 answer
Update sql join multiple tables
SQL
2 votes257 views1 answer
Select a certain number of entries from select mysql
SQL
2 votes231 views2 answers
Change mysql password from command line
SQL
0 vote221 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote239 views4 answers
Get week day from date in sql
SQL
1 vote239 views1 answer
Update mysql centos
SQL
8 votes249 views6 answers
Sql insert
SQL
0 vote247 views1 answer
Wordpress database query change url
SQL
0 vote219 views1 answer
Mysql backup certain tables workbench
SQL
0 vote222 views2 answers
Sql server select first day of previous year
SQL