/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 vote223 views1 answer
How to check xampp mysql password
SQL
2 votes233 views4 answers
Check timezone of mysql database
SQL
0 vote224 views1 answer
Sql server datetime to string
SQL
2 votes212 views2 answers
Sql strip non alphanumeric characters
SQL
2 votes215 views2 answers
How to rename column name in sql server using query
SQL
0 vote212 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
2 votes226 views1 answer
Sql server current date minus 5 years
SQL
0 vote238 views1 answer
Delete duplicate rows
SQL
1 vote211 views1 answer
Is sql fast
SQL
1 vote214 views2 answers
Datetrunc hour snowflake
SQL