/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

1 vote168 views1 answer
Sql update table remove spaces
SQL
0 vote171 views2 answers
Check mysql timezone
SQL
0 vote169 views1 answer
Sql how to display two atributes as one in sql
SQL
2 votes187 views4 answers
Mysql get all tables row count
SQL
6 votes197 views2 answers
How to get yesterday date in mysql
SQL
0 vote173 views1 answer
How to use query in nosql
SQL
0 vote203 views1 answer
Find how many tables in database sql query
SQL
0 vote200 views1 answer
Select nth row in mysql
SQL
10 votes196 views4 answers
SELECT FROM WHERE
SQL
12 votes207 views1 answer
Run mysql instance in docker
SQL