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

14 votes158 views4 answers
Import database through command line
SQL
0 vote164 views1 answer
Tsql pad left
SQL
1 vote160 views1 answer
Postgres count string length
SQL
1 vote168 views1 answer
Mysql curdate between two dates
SQL
2 votes154 views1 answer
Q operator in plsql
SQL
1 vote162 views1 answer
Show table status command in mysql
SQL
3 votes174 views1 answer
Oracle undo tablespace schema
SQL
0 vote152 views4 answers
Postgresql between month
SQL
1 vote146 views1 answer
Mysql show current queries
SQL
2 votes142 views1 answer
Mysql find tables with name
SQL