/SQL/Oracle alter sequence restart start with

Oracle alter sequence restart start with

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 vote109 views1 answer
Logtash mysql cofiguration file
SQL
1 vote108 views1 answer
Raw query must include primary key
SQL
1 vote124 views2 answers
Drop table with constraints
SQL
0 vote99 views1 answer
How to fix mysql stop unexpectedly
SQL
2 votes146 views1 answer
Tcl in sql
SQL
0 vote132 views2 answers
Clauses in mysql
SQL
1 vote74 views1 answer
Import in mysql without a software
SQL
0 vote108 views1 answer
Sql alternative to max statement
SQL
0 vote94 views1 answer
Import sql mysql ubuntu
SQL
0 vote102 views2 answers
Many to many flask-sqlalchemy
SQL