/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

11 votes301 views1 answer
Oracle view ddl
SQL
0 vote294 views1 answer
How to access to mysql without root
SQL
2 votes278 views3 answers
Application.properties spring boot mysql
SQL
0 vote298 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote302 views1 answer
Kill a pid redshift
SQL
0 vote303 views1 answer
How to check event scheduler status mysql
SQL
0 vote295 views1 answer
How to to get current date in sql
SQL
0 vote284 views1 answer
How to find top 3 salary in sql
SQL
0 vote292 views1 answer
Big table in mysql
SQL
1 vote318 views1 answer
Group_concat order by
SQL