/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

7 votes168 views2 answers
How to create index mysql
SQL
0 vote204 views1 answer
Mariadb used space
SQL
27 votes177 views3 answers
Mysql show tables in database
SQL
18 votes141 views3 answers
Mysql query add column with default string value
SQL
0 vote147 views1 answer
User defined variables in sql
SQL
0 vote209 views1 answer
Php insert null mysql
SQL
0 vote163 views1 answer
How we can perform acid Operations in sql with examples
SQL
3 votes214 views1 answer
Apex call duration
SQL
0 vote151 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
23 votes123 views3 answers
Mysqldump
SQL