/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

12 votes111 views4 answers
How to check mysql version ubuntu
SQL
0 vote62 views1 answer
Mysql select top 2
SQL
1 vote94 views1 answer
Postgres get month name from date
SQL
0 vote126 views1 answer
This week mysql
SQL
0 vote95 views1 answer
How to access to mysql without root
SQL
4 votes108 views1 answer
Sql select limit range
SQL
0 vote100 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote124 views1 answer
Connecting mySQL to STS
SQL
0 vote102 views1 answer
Show function mysql
SQL
0 vote113 views1 answer
Select insert new table sql server
SQL