/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

3 votes109 views1 answer
Oracle drop user
SQL
1 vote113 views1 answer
Add multiple row table pl sql
SQL
0 vote96 views1 answer
Mysql sql select one day before
SQL
0 vote105 views1 answer
Create table using the clause with as
SQL
0 vote100 views1 answer
Sqlite update only if greater
SQL
4 votes104 views1 answer
Mysql copy table with new name
SQL
2 votes112 views1 answer
Metasploit start postgresql
SQL
0 vote107 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
2 votes102 views1 answer
While loop sql
SQL
0 vote113 views1 answer
Second Step in installing SQL workbench
SQL