/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 vote229 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
1 vote175 views1 answer
Mysql select another database
SQL
5 votes184 views2 answers
Oracle timestamp to date
SQL
3 votes193 views1 answer
Sql insert inserted id
SQL
0 vote192 views1 answer
Mysql subdate
SQL
0 vote187 views1 answer
Sqlalchemy query join many to many
SQL
0 vote218 views2 answers
Mysql cast to varchar
SQL
0 vote159 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote179 views1 answer
Select all tables linked server sql
SQL
2 votes187 views1 answer
Drop all database tables oracle sql developer
SQL