/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 vote193 views1 answer
Add multiple row table pl sql
SQL
0 vote181 views1 answer
Oracle sql count occurrences of value in column
SQL
24 votes168 views4 answers
How to add column sql
SQL
5 votes163 views1 answer
How to check nls timestamp format in oracle
SQL
3 votes176 views2 answers
Tsql join multiple record in one string
SQL
7 votes151 views1 answer
Mysql load data infile csv
SQL
0 vote173 views2 answers
Postgresql display subquery as json
SQL
0 vote184 views1 answer
Mysql date equals to current_date plus days
SQL
1 vote161 views1 answer
Using SQL in rails migration
SQL
3 votes196 views3 answers
Raw select laravel
SQL