/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

26 votes122 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote127 views1 answer
Heidisql check how much space a row
SQL
2 votes112 views1 answer
Mysql list users on ubuntu
SQL
3 votes110 views1 answer
Oracle nextval
SQL
15 votes254 views2 answers
Sql order by alphabetical
SQL
0 vote132 views1 answer
Query params sql insert python f string
SQL
5 votes114 views1 answer
Mysql get last day of month
SQL
0 vote150 views1 answer
Mysql could not fetch tables
SQL
24 votes128 views4 answers
Postgres remove database
SQL
8 votes124 views3 answers
Oracle auto_increment
SQL