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 vote147 views1 answer
First mysql
SQL
-1 vote189 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
13 votes147 views5 answers
Select last row mysql
SQL
28 votes155 views6 answers
Sql update
SQL
18 votes155 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote166 views1 answer
Foreign key multiple columns
SQL
0 vote152 views1 answer
Oracle archivelog usage
SQL
2 votes147 views3 answers
Postgres remove foreign key constraint
SQL
1 vote198 views1 answer
Ora-01109 database not open in oracle 19c
SQL
9 votes180 views2 answers
Oracle all tables in schema
SQL