/SQL/Alter sequence set current value oracle

Alter sequence set current 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

21 votes166 views6 answers
Update sql
SQL
0 vote177 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote138 views2 answers
Plan d'exécution requete oracle autotracer
SQL
8 votes135 views1 answer
Sql limit results returned
SQL
5 votes179 views3 answers
Create function in postgresql
SQL
0 vote185 views1 answer
Osm2pgsql mac
SQL
3 votes198 views1 answer
Apex call duration
SQL
0 vote146 views3 answers
Delete in SQL SERVER
SQL
3 votes145 views2 answers
How to start postgresql on windows
SQL
0 vote165 views1 answer
How to find unique element in sql
SQL