/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 vote395 views1 answer
Postgresql how to show table names
SQL
0 vote361 views1 answer
How to use group_concat in sql server
SQL
8 votes353 views3 answers
Mysql alter table add index
SQL
1 vote335 views1 answer
Find logged in users mysql
SQL
0 vote390 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote318 views1 answer
Postgres division by zero
SQL
2 votes364 views2 answers
Mysql user access to database
SQL
4 votes510 views6 answers
Laravel jwt
SQL
0 vote402 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
2 votes406 views2 answers
Oracle create table if not exists
SQL