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 vote341 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
3 votes302 views1 answer
Oracle apex message quit website
SQL
1 vote326 views3 answers
How to truncate table with foreign key constraint
SQL
7 votes315 views6 answers
Nth highest salary in sql
SQL
0 vote314 views1 answer
Postgresql default value boolean
SQL
6 votes317 views2 answers
Stored procedure to delete data from table in mysql
SQL
31 votes312 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote298 views1 answer
Sql database size
SQL
0 vote298 views1 answer
Oracle create package body
SQL
0 vote312 views1 answer
Get cpu details sql
SQL