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

0 vote157 views2 answers
Sql update from two different database
SQL
1 vote215 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote203 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote189 views3 answers
Get free card roblox
SQL
0 vote207 views2 answers
Select last 30 days sql
SQL
8 votes148 views2 answers
Alter column name in mssql
SQL
0 vote191 views1 answer
Allow external access to mysql
SQL
8 votes186 views3 answers
Alter table auto_increment
SQL
0 vote205 views1 answer
Sql server convert to guid
SQL
2 votes193 views1 answer
Mariadb JSON_EXTRACT
SQL