Oracle reset sequence

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 vote185 views1 answer
Ms sql unique
SQL
-1 vote200 views1 answer
Ms sql select datetime as date
SQL
1 vote189 views1 answer
Postgresql how to show table names
SQL
0 vote141 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote186 views1 answer
Pl/ sql change currency
SQL
2 votes147 views4 answers
Mysql change database character set to utf8mb4
SQL
20 votes197 views4 answers
Reset auto increment in MySQL
SQL
0 vote206 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
-1 vote192 views1 answer
Io
SQL
1 vote175 views1 answer
Sql get all columns from one table but one from another inner join
SQL