/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

28 votes159 views4 answers
Mysql delete database
SQL
1 vote168 views1 answer
Find a column in all tables postgres
SQL
0 vote172 views1 answer
Add sqlcmd to path linux
SQL
0 vote187 views1 answer
How to locate pg_hba.conf file
SQL
21 votes175 views5 answers
Oracle all tables
SQL
0 vote179 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
2 votes173 views1 answer
Mysql create user with remote access
SQL
0 vote172 views1 answer
Test connection to sql server
SQL
0 vote175 views2 answers
Mysql two column combination unique
SQL
0 vote182 views1 answer
Dbms_output sql developer
SQL