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

8 votes122 views4 answers
Postgresql server restart
SQL
2 votes128 views5 answers
Install postgresql 10 centos 7
SQL
13 votes110 views5 answers
Oracle list tables
SQL
1 vote127 views1 answer
Mysql search like order by best match
SQL
0 vote154 views1 answer
Split first name and last name in sql
SQL
1 vote118 views1 answer
Deleting database in sql
SQL
0 vote121 views1 answer
Mysql cast null to string
SQL
0 vote123 views1 answer
Convert multiple columns to ROws in sql server
SQL
1 vote122 views1 answer
Apex select list ORA-20999
SQL
1 vote72 views1 answer
Postgres kill pid
SQL