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 vote265 views1 answer
Pl sql search in all packages
SQL
1 vote275 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote275 views1 answer
PL SQL MODIFY COLUMN NME
SQL
2 votes279 views1 answer
Oracle apex list connected users
SQL
-1 vote273 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote267 views1 answer
Oracle execute package dblink
SQL
1 vote260 views1 answer
Mysql Case sum
SQL
26 votes220 views10 answers
Insert in to table sql
SQL
1 vote274 views1 answer
Alphabetical order mysql
SQL
8 votes269 views1 answer
Oracle search source code
SQL