Oracle reset sequence

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 vote134 views1 answer
Oracle truncate partition
SQL
4 votes140 views1 answer
Sql delete where in select
SQL
14 votes150 views6 answers
Auto_increment mysql
SQL
1 vote140 views3 answers
Get all tables postgres
SQL
0 vote205 views1 answer
Jpa generationtype sequence mysql
SQL
3 votes154 views6 answers
DB::table('users')->get();
SQL
0 vote155 views1 answer
Mysql error 1251
SQL
0 vote144 views1 answer
Create table database in psql
SQL
-1 vote129 views2 answers
How to select the lowest values from table per client sql
SQL
-1 vote181 views1 answer
Pl sql drop trigger
SQL