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

1 vote258 views2 answers
Update with inner join sql server
SQL
0 vote287 views3 answers
How to increase size of column in sql
SQL
-1 vote250 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote264 views3 answers
Find below average salary in sql
SQL
0 vote272 views1 answer
Sql count matching group by
SQL
0 vote267 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote266 views1 answer
Longtext sql
SQL
0 vote284 views1 answer
Sql change primary key to composite key
SQL
2 votes268 views1 answer
Mysql Incorrect column specifier for column
SQL
21 votes263 views3 answers
Sql average
SQL