/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 vote143 views1 answer
Sql delete dastabase
SQL
3 votes141 views1 answer
Postgres add not null to existing column
SQL
0 vote139 views1 answer
Mysql update privileges
SQL
42 votes216 views6 answers
Rename table sql server
SQL
0 vote135 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
1 vote135 views1 answer
Sql get missing id
SQL
3 votes135 views2 answers
Postgres show table schema
SQL
0 vote123 views3 answers
Joins and views sql
SQL
31 votes142 views2 answers
Grant all priviledges to mysql user
SQL
8 votes143 views2 answers
Python simple connect to mysql
SQL