/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 votes319 views1 answer
Docker run postgres locally
SQL
4 votes328 views1 answer
What are the data types in sql
SQL
1 vote330 views1 answer
Mysql batch insert
SQL
7 votes304 views1 answer
Mysql load data infile csv
SQL
1 vote368 views1 answer
Mysql text to decimal
SQL
1 vote343 views1 answer
How to unlock table in mysql
SQL
0 vote346 views1 answer
Sql period overlap
SQL
0 vote329 views1 answer
Sql server inner join convert collation
SQL
0 vote344 views1 answer
Postgres drop type
SQL
2 votes393 views1 answer
Remove foreign key constraints in postgres
SQL