/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

1 vote192 views2 answers
Postgresql check privileges on schema
SQL
2 votes186 views1 answer
How to make insert script from table in SQL server
SQL
0 vote208 views1 answer
Sqlite version check
SQL
4 votes172 views1 answer
Delete record mysql query
SQL
0 vote212 views3 answers
Mysql CAST(amount as float)
SQL
2 votes181 views1 answer
Convert series number to date in sql
SQL
4 votes197 views1 answer
Search column by name mysql
SQL
-1 vote190 views5 answers
Convert sql to linq query online
SQL
3 votes182 views3 answers
C# sql select
SQL
0 vote211 views1 answer
Sql insert query list of dictionaries
SQL