/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 vote251 views1 answer
Sql get count without group by
SQL
0 vote232 views1 answer
Get week day name sql server
SQL
0 vote239 views1 answer
Mysql get last 2 month data
SQL
7 votes231 views1 answer
Safe update mysql
SQL
0 vote229 views1 answer
Docker export psql sql
SQL
9 votes251 views2 answers
Nosql databases
SQL
0 vote200 views1 answer
Mysql timeout 30 seconds
SQL
0 vote241 views2 answers
Update query with between in mysql
SQL
21 votes231 views6 answers
Docker run mysql
SQL
1 vote254 views1 answer
Mysql connect bash
SQL