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 vote248 views1 answer
MySQL error code 2068
SQL
0 vote262 views1 answer
Sql column as header
SQL
0 vote267 views1 answer
Query archive mode
SQL
59 votes435 views6 answers
Alter table sql
SQL
0 vote237 views1 answer
SQL server select to get sum of hours
SQL
10 votes323 views4 answers
Join multiple tables in sql
SQL
0 vote252 views2 answers
What is 1=2 in sql
SQL
0 vote253 views1 answer
How to query all tables mysql at the same time
SQL
0 vote259 views1 answer
Drop a field in psql django
SQL
0 vote268 views1 answer
Php get closest location by latitude longitude
SQL