/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

0 vote282 views1 answer
Connect postgresql using a connection string
SQL
0 vote319 views1 answer
How to get table id sequence postgres
SQL
0 vote297 views1 answer
Oracle change password expiration policy
SQL
1 vote318 views1 answer
Mysql take number in string
SQL
0 vote359 views1 answer
Trigger
SQL
6 votes356 views2 answers
Oracle compile trigger
SQL
1 vote270 views1 answer
Import database from a file using mysql commandline
SQL
1 vote294 views1 answer
Sql server cast date dd/mm/yyyy
SQL
10 votes275 views4 answers
Primary key sql
SQL
0 vote274 views1 answer
Mysql select where text contains
SQL