/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 vote199 views2 answers
Select limit ms sql
SQL
0 vote184 views1 answer
Ms Sql set us timezone
SQL
0 vote212 views1 answer
Can't connect to postgresql mac os
SQL
7 votes208 views2 answers
Oracle sql drop index
SQL
0 vote204 views1 answer
SQL authentication error
SQL
3 votes203 views2 answers
Oracle grants
SQL
0 vote161 views1 answer
Sqlalchemy filter relationship
SQL
16 votes222 views3 answers
Jwt secret key generator laravel
SQL
0 vote199 views1 answer
Composit key in sql
SQL
0 vote198 views2 answers
Demmarrer un service mysql teminal cmd
SQL