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

5 votes131 views2 answers
Sql constraint check value in list
SQL
0 vote133 views1 answer
Drop view in mysql
SQL
1 vote120 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote126 views2 answers
Auto increment column in mysql query results
SQL
1 vote139 views1 answer
Oracle sequence last_number
SQL
0 vote122 views1 answer
Mysql search multiple tables
SQL
0 vote131 views1 answer
Sql period overlap
SQL
3 votes118 views3 answers
Print in pl sql
SQL
0 vote140 views1 answer
How to read the potentail error messages in ssis package
SQL
1 vote120 views1 answer
Sql myisam vs innodb
SQL