/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 vote96 views1 answer
Oracle function select into
SQL
8 votes150 views1 answer
Oracle add datafile to tablespace
SQL
1 vote153 views2 answers
This month mysql where
SQL
0 vote128 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote134 views1 answer
Postgresql create table with boolean column
SQL
1 vote140 views1 answer
Timestamp in sqlite
SQL
4 votes146 views1 answer
Refresh postgres config
SQL
0 vote140 views1 answer
Pl sql search saurce code
SQL
0 vote137 views1 answer
Move table to a different schema
SQL
1 vote145 views2 answers
Mysql remove first and last character from string
SQL