/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 vote254 views1 answer
Mysql multiple group by
SQL
0 vote177 views1 answer
Mysql cli output to a file
SQL
3 votes242 views2 answers
Oracle privileges users
SQL
0 vote180 views1 answer
Sql server set complex constraints
SQL
1 vote182 views2 answers
Postgres copy table from one schema to another
SQL
1 vote173 views1 answer
Mysql check if string contains comma separated
SQL
3 votes200 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
3 votes216 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote172 views1 answer
Sql trim whitespace
SQL
3 votes181 views2 answers
Oracle for loop
SQL