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 vote375 views1 answer
Isnull in sqlite
SQL
2 votes396 views3 answers
Postgres json to string
SQL
6 votes365 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote375 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote341 views1 answer
Postgresql get current user name
SQL
0 vote385 views1 answer
Insert ip address in mysql
SQL
5 votes355 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote368 views1 answer
Postgres start database on linux
SQL
0 vote394 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote344 views1 answer
Sql string length postgresql
SQL