Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

select nextval from sequence sql

SELECT schema.seq_name.NEXTVAL FROM dual;

INSERT INTO table_name (VALUE1) VALUES (
	schema.seq_name.NEXTVAL AS VALUE1
);
Source by www.dba-oracle.com #
 
PREVIOUS NEXT
Tagged: #select #nextval #sequence #sql
ADD COMMENT
Topic
Name
7+3 =