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 vote196 views1 answer
See Foreign Key
SQL
24 votes172 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote200 views1 answer
Postgres data location
SQL
0 vote196 views1 answer
Linked server delete openquery
SQL
0 vote246 views1 answer
Delete from IN subquery
SQL
0 vote198 views1 answer
Lost connection to mysql
SQL
10 votes197 views2 answers
Sql rtrim
SQL
1 vote159 views1 answer
Mysql collation
SQL
0 vote189 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
5 votes184 views2 answers
Sql conn
SQL