/SQL/Oracle alter sequence restart start with

Oracle alter sequence restart start with

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 vote155 views1 answer
Sqlite insert or update
SQL
0 vote149 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote155 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote215 views1 answer
How do you insert boolean to postgresql
SQL
0 vote144 views1 answer
Change permission to database mysql
SQL
2 votes145 views2 answers
Sqlalchemy filter or
SQL
1 vote149 views1 answer
Sql run multiple updates in one query
SQL
2 votes199 views3 answers
Mysql kill
SQL
-2 votes156 views1 answer
Create trigger syntax
SQL
2 votes154 views2 answers
Set database timezone mysql
SQL