/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

5 votes159 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
13 votes130 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote129 views1 answer
How to use sqlcommand
SQL
62 votes176 views8 answers
Mysql add column
SQL
16 votes145 views3 answers
Get count of duplicate records
SQL
1 vote117 views1 answer
How to get mysql db size
SQL
1 vote125 views1 answer
Base nosql
SQL
1 vote127 views4 answers
Psql check tables command
SQL
0 vote203 views1 answer
Bigrock database connection string
SQL
0 vote125 views1 answer
FIND most frequent word in sql server
SQL