/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

25 votes354 views3 answers
Mysql command show tables
SQL
0 vote337 views1 answer
How to find unique key in sql
SQL
2 votes347 views1 answer
Sql create database
SQL
0 vote352 views2 answers
Mysql regexp match word
SQL
3 votes349 views2 answers
Truncate all tables
SQL
3 votes464 views1 answer
Sql select second max
SQL
4 votes338 views2 answers
Dbms_scheduler stop job
SQL
0 vote338 views1 answer
Xampp mysql version
SQL
0 vote381 views1 answer
Mysql faster delete
SQL
5 votes353 views1 answer
JBDC
SQL