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

3 votes277 views2 answers
Oracle for loop
SQL
0 vote348 views1 answer
Sql server query all database objects
SQL
0 vote321 views1 answer
Firebase sql
SQL
0 vote297 views1 answer
Sql character index
SQL
1 vote292 views2 answers
Sql multiline comment
SQL
0 vote313 views1 answer
Mysql uuid
SQL
15 votes334 views3 answers
Mysql update add to existing value
SQL
0 vote323 views1 answer
Mysql case when on date
SQL
1 vote293 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
2 votes309 views1 answer
How to delete all duplicate items in mysql
SQL