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

2 votes372 views5 answers
Install postgresql 10 centos 7
SQL
49 votes392 views6 answers
Get duplicate records in sql
SQL
0 vote365 views1 answer
Sql common columns
SQL
0 vote400 views1 answer
Sql decimal to 2 places
SQL
1 vote371 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote330 views1 answer
Sqlserver now
SQL
12 votes350 views1 answer
Docker mysql random root password
SQL
0 vote340 views1 answer
Use where instead of join
SQL
0 vote344 views2 answers
Postgresql display subquery as json
SQL
1 vote334 views1 answer
Load sql into mamp
SQL