/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

3 votes207 views2 answers
Sql server current date without time
SQL
0 vote189 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote189 views1 answer
How to connect pgadmin with excel
SQL
3 votes201 views1 answer
Postgresql if null then 0
SQL
0 vote199 views1 answer
Alter rename command in mysql
SQL
1 vote197 views1 answer
Select count distinct multiple columns sql server
SQL
3 votes192 views1 answer
How to find names includes in sql
SQL
1 vote148 views1 answer
Ms sql - add one hour to time
SQL
1 vote182 views5 answers
Sql 2nd highest salary
SQL
0 vote231 views1 answer
How to define a non primary composite key in sql
SQL