/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 vote115 views1 answer
What is default mysql database password in linux
SQL
0 vote130 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote110 views1 answer
Use where instead of join
SQL
0 vote123 views1 answer
Sqlalchemy query join many to many
SQL
5 votes113 views1 answer
Oracle find foreign key dependencies
SQL
1 vote112 views1 answer
Sql comment header
SQL
2 votes121 views2 answers
Mysql on duplicate key ignore
SQL
0 vote114 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote129 views1 answer
Oracle insert single quote in string
SQL
0 vote130 views1 answer
How to create notes in mysql
SQL