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 vote202 views1 answer
Database springboot
SQL
0 vote222 views1 answer
Declare date variable sql
SQL
0 vote218 views1 answer
Sql server insert inner join
SQL
8 votes213 views1 answer
Insert a select statement into a table
SQL
6 votes230 views3 answers
How to delete table sqlite
SQL
0 vote272 views1 answer
Reindexing all tables sql server
SQL
0 vote212 views1 answer
Export partttion and import in oracle
SQL
1 vote230 views1 answer
Age postgres
SQL
0 vote217 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote221 views1 answer
Primary key multiple colums
SQL