/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 vote164 views1 answer
Oracle sql procedure return value
SQL
0 vote235 views1 answer
Consulta alias con inner join
SQL
3 votes194 views1 answer
What is having
SQL
0 vote177 views1 answer
Sql server change schema of a table
SQL
3 votes204 views3 answers
Docker create postgresql database
SQL
18 votes178 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote166 views1 answer
Update set with inner join oracle
SQL
13 votes177 views2 answers
Get date from now() mysql
SQL
1 vote177 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote212 views1 answer
How to subquey to do not load in live database in
SQL