/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 vote153 views1 answer
How to check replication lag in mySQL
SQL
5 votes162 views2 answers
Create function postgresql
SQL
1 vote157 views1 answer
Date in where on datetime column clause mysql
SQL
8 votes147 views2 answers
Between operator
SQL
1 vote138 views2 answers
Mysql type conversion
SQL
0 vote160 views1 answer
Querry mysql by 2 columns
SQL
0 vote163 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote158 views1 answer
Oracle sql drop table
SQL
0 vote145 views1 answer
Postgresql update to unique
SQL
8 votes146 views2 answers
Update sql server from another table
SQL