select nextval from sequence oracle

1SELECT LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = 'seq_name';
2
3ALTER SEQUENCE seq_name INCREMENT BY 100;	-- Value to reach desired value - 1
4SELECT seq_name.nextval FROM dual;			-- Reinitialize value to desired
5ALTER SEQUENCE seq_name INCREMENT BY 1;		-- Back to init step

1SELECT schema.seq_name.NEXTVAL FROM dual;
2
3INSERT INTO table_name (VALUE1) VALUES (
4	schema.seq_name.NEXTVAL AS VALUE1
5);

1 select sec_codigolibros.nextval from dual;
2