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

6 votes774 views3 answers
Sql select last id
SQL
-1 vote330 views1 answer
Mac mysql workbench console
SQL
0 vote347 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote327 views2 answers
Azure sql-datenbank
SQL
9 votes342 views2 answers
Sql limit to 5 results
SQL
0 vote388 views3 answers
Constraint sql
SQL
1 vote359 views1 answer
Sql server delete top 1000
SQL
0 vote392 views3 answers
How to find all role in mysql
SQL
0 vote360 views1 answer
Psql store procedure-return multiple table values
SQL
1 vote346 views1 answer
Postgres check blocking
SQL