/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

3 votes185 views2 answers
How to load files in mysql
SQL
1 vote230 views1 answer
Sql in array query
SQL
1 vote192 views2 answers
Mysql switch case
SQL
0 vote189 views1 answer
Mysql zerofill
SQL
0 vote131 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote183 views1 answer
Null column as zero in mysql
SQL
2 votes180 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote196 views1 answer
SQL server datetime compare
SQL
0 vote218 views1 answer
Postgres docs /copy metacomand
SQL
7 votes189 views1 answer
Sql server management studio turn on line numbers
SQL