/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 vote123 views2 answers
Postgresql get long running queries
SQL
1 vote108 views1 answer
Too many connections mysql
SQL
3 votes116 views2 answers
Postgresql remove not null constraint
SQL
2 votes241 views2 answers
MySql FULL OUTER JOIN
SQL
8 votes159 views2 answers
Default sql server port
SQL
0 vote132 views1 answer
Cannot start database server xampp mac os
SQL
1 vote119 views1 answer
Import database from a file using mysql commandline
SQL
13 votes136 views2 answers
Sql join 3 tables
SQL
2 votes138 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
10 votes137 views2 answers
Select nextval from sequence oracle
SQL