Oracle alter sequence nextval

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

Select nextval from sequence oracle

SELECT schema.seq_name.NEXTVAL FROM dual;

INSERT INTO table_name (VALUE1) VALUES (
	schema.seq_name.NEXTVAL AS VALUE1
);

Source: dba-oracle.com

Similar codes

7 votes246 views3 answers
Sql update where id
SQL
0 vote214 views1 answer
Update view sql
SQL
0 vote228 views1 answer
Search from comma separated values in sql server
SQL
0 vote234 views1 answer
Sql if clause within where clause
SQL
0 vote211 views1 answer
Oracle free up space in tablespace
SQL
3 votes247 views2 answers
Check data in table mysql
SQL
19 votes213 views6 answers
Sql create table
SQL
0 vote209 views1 answer
Oracle synonym procedure
SQL
0 vote232 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote234 views1 answer
Left join vs inner join performance
SQL