/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

2 votes338 views1 answer
Tsql copy table
SQL
-1 vote249 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote203 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote201 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote241 views1 answer
Concat column value of same user in mysql
SQL
50 votes276 views4 answers
Sql alter type of column
SQL
0 vote184 views1 answer
Oracle select invalid views
SQL
0 vote194 views1 answer
Sql insert tuple
SQL
0 vote168 views1 answer
Import csv to mysql
SQL
4 votes224 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL