/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

6 votes276 views2 answers
How to copy data in sql
SQL
0 vote228 views1 answer
Calculate discount from original price sql
SQL
0 vote277 views2 answers
Mysql on update current_timestamp
SQL
6 votes276 views1 answer
Oracle trigger after logon on schema
SQL
0 vote278 views1 answer
Search In the Database using Text
SQL
1 vote297 views1 answer
Update from table tsql
SQL
0 vote289 views2 answers
Unique key
SQL
1 vote250 views1 answer
Find logged in users mysql
SQL
0 vote263 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
47 votes338 views6 answers
Add column mysql
SQL