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 vote183 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote162 views4 answers
Rownum in sql
SQL
1 vote318 views1 answer
Postgres upgrade to superuser
SQL
1 vote253 views1 answer
Sql and
SQL
0 vote165 views1 answer
Mariadb hours between two dates
SQL
0 vote182 views1 answer
Php select data from mysql database without column name
SQL
1 vote168 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote170 views3 answers
CONTACT FORM SQL
SQL
0 vote172 views1 answer
Create mysql pool connection python flask
SQL
0 vote162 views1 answer
Pl sql search saurce code
SQL