/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

1 vote232 views2 answers
Login to mysql
SQL
0 vote341 views1 answer
How to use select union and loop
SQL
8 votes222 views4 answers
Postgresql server restart
SQL
0 vote233 views1 answer
SQL get max per id
SQL
15 votes244 views4 answers
Export mysql db using command line
SQL
0 vote182 views1 answer
Python sql last insertend
SQL
0 vote142 views1 answer
Procedures and functions in pl/sql
SQL
12 votes194 views4 answers
Mysql version
SQL
0 vote200 views1 answer
Mysql:5.6 syntax create table
SQL
16 votes210 views1 answer
Sql comment'
SQL