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

5 votes170 views3 answers
Sql max value in column
SQL
0 vote163 views1 answer
Inserted row count tsql
SQL
0 vote166 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
2 votes194 views2 answers
Install postgresql
SQL
0 vote172 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
0 vote157 views1 answer
Oracle query archive mode
SQL
3 votes180 views1 answer
Oracle limit user tablespace
SQL
0 vote164 views1 answer
Oracle call a function in a insert statement
SQL
1 vote207 views1 answer
Oracle columns table
SQL
0 vote166 views1 answer
Sql pad left 0
SQL