/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

9 votes214 views6 answers
Oracle substring
SQL
2 votes182 views1 answer
Get first 3 letters name in sql
SQL
0 vote208 views1 answer
Postgres change the name of schema
SQL
0 vote206 views1 answer
How to run mysql in git bash
SQL
4 votes234 views1 answer
Rename stored procedure in sql server
SQL
0 vote192 views1 answer
Postgresql delete multiple rows
SQL
0 vote218 views1 answer
Repeatable read trong sql server
SQL
9 votes246 views6 answers
Replace sql
SQL
0 vote180 views1 answer
Order by monthly in sql
SQL
0 vote223 views1 answer
Sqlalchemy empty table
SQL