/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

2 votes368 views2 answers
Oracle create table if not exists
SQL
0 vote318 views1 answer
Mysql could not fetch tables
SQL
4 votes323 views4 answers
Sqlite describe table
SQL
11 votes311 views2 answers
Import sql file laravel cmd
SQL
0 vote324 views1 answer
Postgresql default value boolean
SQL
1 vote312 views1 answer
Oracle rolling back transactions
SQL
1 vote308 views1 answer
Oracle first row
SQL
0 vote357 views2 answers
Port 5432 is already in use mac
SQL
0 vote338 views1 answer
Php mysqli install
SQL
4 votes350 views1 answer
Oracle nls_date_format
SQL