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

0 vote329 views1 answer
Geopoint from json mysql function
SQL
10 votes295 views2 answers
Mysql select timestamp group by day
SQL
2 votes331 views1 answer
Can you use a where clause for a child query
SQL
4 votes301 views1 answer
Wilayah indonesia sql
SQL
0 vote310 views1 answer
Postgresql select fast check no rows
SQL
1 vote316 views1 answer
Postgres install unaccent extension
SQL
0 vote312 views1 answer
Postgresql array to rows
SQL
3 votes462 views9 answers
Linq to sql converter online
SQL
1 vote312 views1 answer
Psql datetime grather than
SQL
6 votes366 views2 answers
How to get last element sql
SQL