/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 vote305 views1 answer
Except in sql alchemy
SQL
0 vote300 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
2 votes337 views3 answers
Sql truncate table
SQL
1 vote319 views1 answer
Does insert into overwrite sql
SQL
0 vote336 views1 answer
Sqlite insert or update
SQL
0 vote377 views1 answer
Sql query to select even numbers
SQL
0 vote316 views1 answer
Oracle procedure chain step
SQL
0 vote311 views1 answer
Sql server isnull function nor working count
SQL
0 vote324 views1 answer
Min mysql
SQL
0 vote371 views1 answer
Select * from mysql.proc
SQL