/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

0 vote197 views1 answer
Mysql drop vs delete
SQL
0 vote241 views1 answer
Oracle swap partition
SQL
2 votes195 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote184 views1 answer
Find all tables where column name exists oracle
SQL
0 vote246 views1 answer
T-sql delete view if exists
SQL
0 vote193 views1 answer
Check if database exists sql
SQL
8 votes163 views1 answer
Oracle current date plus 1 month
SQL
3 votes220 views3 answers
Order by postgres
SQL
0 vote191 views1 answer
Oracle last user logon
SQL
0 vote195 views1 answer
Oracle query to find schema you are working on
SQL