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

8 votes256 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote286 views2 answers
How to install psql in ubuntu
SQL
0 vote239 views1 answer
Get duplicate entry sql
SQL
4 votes288 views1 answer
Postgres delete last row
SQL
1 vote257 views1 answer
Mysql batch insert
SQL
0 vote273 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote266 views1 answer
Alter table engine mysql
SQL
17 votes255 views6 answers
What is cursor in sql server with example
SQL
-1 vote251 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote210 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL