/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 vote275 views4 answers
Alter schema sql
SQL
0 vote271 views1 answer
Mysql foreach insert
SQL
0 vote303 views2 answers
Mysql dump database tables only
SQL
1 vote265 views1 answer
Real world example of nosql
SQL
0 vote266 views1 answer
TSQL function split string
SQL
3 votes276 views2 answers
Truncate all tables
SQL
0 vote288 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote254 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote295 views1 answer
Hashpass
SQL
9 votes259 views6 answers
Sql insert into
SQL