/SQL/Oracle alter sequence restart start with

Oracle alter sequence restart start with

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

2 votes284 views1 answer
Username sql
SQL
0 vote310 views1 answer
Subquery aggregation
SQL
4 votes293 views2 answers
Sql vs mysql
SQL
3 votes315 views1 answer
Oracle sleep
SQL
0 vote299 views1 answer
Order by ip address sql
SQL
0 vote340 views3 answers
Select top 10 rows in sql
SQL
0 vote299 views1 answer
Query to insert image
SQL
0 vote293 views1 answer
Bigquery declare
SQL
-1 vote319 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote300 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL