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

-1 vote183 views1 answer
Export mysql table to file
SQL
0 vote188 views1 answer
Sql create text column limited values
SQL
0 vote192 views1 answer
Connect to ssms with python
SQL
1 vote148 views1 answer
Unique vs distinct sql
SQL
0 vote209 views2 answers
Reseed sql identity
SQL
0 vote195 views4 answers
Mysql count table rows
SQL
0 vote196 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote182 views5 answers
Sql 2nd highest salary
SQL
0 vote213 views1 answer
Mysql grant all on all databases
SQL
0 vote194 views1 answer
Opening xampp mysql in cmd ubuntu
SQL