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 vote346 views1 answer
Round function in sql oracle
SQL
0 vote350 views1 answer
Compare field sql server
SQL
24 votes315 views4 answers
Mssql get all table names
SQL
10 votes353 views2 answers
SQL rounding numbers
SQL
12 votes332 views4 answers
Mysql get date difference in hours
SQL
3 votes330 views3 answers
Update join
SQL
17 votes358 views4 answers
Show tables sql server
SQL
0 vote285 views1 answer
Sqlalchemy filter relationship
SQL
15 votes596 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote348 views1 answer
SQL SERVER xquery count child nodes
SQL