Answers for "how to use sequence.nextval in insert statement in oracle"

oracle nextval insert

SELECT schema.seq_name.NEXTVAL FROM dual;

INSERT INTO table_name (VALUE1) VALUES (
	schema.seq_name.NEXTVAL AS VALUE1
);

Posted by: Guest on July-11-2021

Code answers related to "how to use sequence.nextval in insert statement in oracle"