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

31 votes131 views3 answers
SQL Server change column data type
SQL
0 vote129 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote130 views1 answer
Linebreak sql
SQL
1 vote136 views1 answer
Postgres regex remove special characters
SQL
11 votes145 views2 answers
Having keyword sql
SQL
0 vote149 views1 answer
Python sqlalchemy connection show server
SQL
22 votes132 views4 answers
Mysql reset auto increment id
SQL
6 votes176 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote130 views1 answer
Mysql replication change database name
SQL
8 votes171 views3 answers
Postgres database sizes
SQL