/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 vote250 views1 answer
Mysql shell set time_zone
SQL
0 vote261 views1 answer
Sql server list user permissions
SQL
0 vote234 views1 answer
Sql comparison operators
SQL
0 vote278 views1 answer
Mariadb change column type
SQL
0 vote280 views2 answers
Wordpress change url after migration mysql query
SQL
1 vote309 views1 answer
How not to sort by average rating
SQL
0 vote257 views1 answer
Sequelize postgresql schema
SQL
1 vote239 views1 answer
How to delete record sql delphi
SQL
1 vote268 views1 answer
Oracle drop job if exists
SQL
0 vote214 views0 answer
SQL