/SQL/Alter sequence set current value oracle

Alter sequence set current 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 vote253 views1 answer
Turn on foreign keys check mysql
SQL
7 votes201 views2 answers
Show size database mysql
SQL
0 vote171 views1 answer
Query for maximum salary
SQL
0 vote194 views1 answer
Sqlite update only if greater
SQL
1 vote201 views1 answer
Get all db sizes in mysql server
SQL
34 votes237 views5 answers
Oracle alter table add column
SQL
23 votes211 views5 answers
Sql substring
SQL
1 vote196 views1 answer
Find logged in users mysql
SQL
1 vote154 views1 answer
Alter user mysql native password
SQL
0 vote229 views1 answer
C# select Mysql
SQL