/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 vote325 views1 answer
STOP message of how many rows affected sql
SQL
2 votes284 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote281 views1 answer
Php select data from mysql database without column name
SQL
0 vote348 views1 answer
Trigger
SQL
5 votes245 views1 answer
Postgres upsert
SQL
38 votes326 views6 answers
Alter table mysql
SQL
0 vote267 views1 answer
Hibernate with springboot mysql
SQL
11 votes303 views2 answers
Oracle saurce code
SQL
4 votes274 views3 answers
How to describe a table in sqlite3
SQL
10 votes322 views6 answers
Mysql set root password
SQL