/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 vote114 views1 answer
Dns slave zone convert
SQL
0 vote120 views1 answer
Can't connect to postgresql mac os
SQL
0 vote111 views1 answer
Oracle exchange subpartition
SQL
0 vote122 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote117 views1 answer
18446744073709551615 mariadb left join order by
SQL
2 votes117 views2 answers
How to check data type in sql server
SQL
12 votes121 views6 answers
Between in sql
SQL
0 vote121 views1 answer
Mssql dockere
SQL
1 vote109 views3 answers
String to int mysql
SQL
6 votes129 views1 answer
Oracle rank
SQL