Set sequence value oracle

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 vote318 views1 answer
Get cpu details sql
SQL
0 vote338 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote317 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote339 views1 answer
How to add session data into mysql database from button
SQL
1 vote345 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote352 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
2 votes312 views1 answer
Drop table if exists in postgres
SQL
2 votes336 views4 answers
2nd highest salary in mysql
SQL
60 votes537 views6 answers
Add column in sql
SQL
24 votes322 views5 answers
Sql server insert into select
SQL