Set sequence value oracle

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

7 votes264 views1 answer
Show line number in sql server
SQL
0 vote209 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote207 views1 answer
Online sql testing tool
SQL
0 vote222 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote209 views1 answer
Get foreign table names mysql
SQL
1 vote214 views1 answer
Sql server update column based on another table
SQL
0 vote229 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
26 votes216 views6 answers
Modify column name in sql
SQL
0 vote230 views1 answer
Import Data in MySQL without using any other software
SQL
3 votes212 views1 answer
Export postgres database linux
SQL