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

1 vote149 views1 answer
Sql get missing id
SQL
1 vote146 views2 answers
Mssql show database size
SQL
0 vote152 views1 answer
Oracle db timestamp auto add
SQL
1 vote175 views1 answer
Sql in array query
SQL
0 vote187 views1 answer
Get enginge db mysql
SQL
0 vote137 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
4 votes112 views2 answers
Select todays data postgres query
SQL
0 vote211 views1 answer
Do you know sql
SQL
0 vote147 views1 answer
Mysql xampp reset root password
SQL
0 vote153 views2 answers
Laravel: customize or extend notifications - database model
SQL