/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 vote149 views1 answer
Backup mysql schema only
SQL
0 vote113 views1 answer
Mysql error 1452
SQL
9 votes124 views4 answers
How to create new user and database postgresql in ubuntu
SQL
5 votes116 views1 answer
Sqlite alter table add column
SQL
1 vote143 views1 answer
Mysql not supported auth mode
SQL
7 votes144 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
2 votes141 views1 answer
Oracle percentage
SQL
1 vote177 views2 answers
Truncate table sqlite
SQL
0 vote119 views1 answer
Remove default constraint sql server
SQL
2 votes146 views4 answers
List databases in sql server
SQL