/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 vote171 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote162 views2 answers
Get table column names sql laravel
SQL
4 votes180 views2 answers
DB::transaction
SQL
1 vote166 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote170 views1 answer
Oracle allow space to user
SQL
0 vote143 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
1 vote158 views1 answer
Spark sql concatenate string and int
SQL
1 vote156 views1 answer
Oracle sql average
SQL
7 votes144 views3 answers
Add primary key to database sql
SQL
1 vote374 views1 answer
How to make a select in sql
SQL