Set sequence value oracle

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 vote220 views1 answer
How to find the most occuring in SQL
SQL
-1 vote242 views1 answer
Auto increment psql not primary key
SQL
0 vote238 views1 answer
Select all columns except one sql
SQL
42 votes255 views6 answers
Sql query duplicate rows
SQL
1 vote221 views1 answer
Create table variable in sql stored procedure
SQL
0 vote234 views1 answer
Null column as zero in mysql
SQL
0 vote263 views1 answer
Pgadmin check database
SQL
19 votes222 views2 answers
Mysql add column after another
SQL
0 vote227 views1 answer
Mysql identified by syntax error
SQL
1 vote233 views1 answer
Mysql strict_trans_tables
SQL