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 vote324 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote362 views1 answer
Count columns psql(PostreSQL)
SQL
1 vote323 views1 answer
Load sql into mamp
SQL
0 vote373 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote323 views1 answer
Mysql terminal list table
SQL
1 vote354 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
15 votes331 views6 answers
Psql
SQL
1 vote340 views1 answer
Pl sql insert into table
SQL
10 votes340 views5 answers
Between keyword in sql
SQL
0 vote355 views1 answer
Sql last 3 rows
SQL