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 vote128 views1 answer
What is logical database schema
SQL
0 vote133 views1 answer
Sql server check whether column has same equal values
SQL
0 vote144 views1 answer
How to add timestamp column in mysql
SQL
1 vote145 views3 answers
How to pass password to mysql command line
SQL
3 votes150 views2 answers
How to force truncate a table in mysql
SQL
0 vote140 views1 answer
Mysql procedure between two tables
SQL
8 votes139 views1 answer
Oracle search source code
SQL
0 vote172 views1 answer
DATEDIFF minute postgres
SQL
2 votes123 views1 answer
Mysql list users on ubuntu
SQL
0 vote196 views1 answer
Sqlite schema structure of a relational database
SQL