/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 vote154 views3 answers
Sql drop all tables
SQL
0 vote210 views3 answers
How to find all role in mysql
SQL
0 vote130 views1 answer
Change default schema sql server
SQL
0 vote144 views1 answer
Pl sql turn off variable substitution
SQL
0 vote131 views1 answer
Mysql regex exact match
SQL
0 vote152 views3 answers
Sql delete all except
SQL
0 vote143 views1 answer
Oracle last connection
SQL
0 vote138 views1 answer
Insert or update cassandra
SQL
0 vote150 views1 answer
Sql include rows with 0 values
SQL
10 votes150 views6 answers
Between sql
SQL