Purpose of using Nextval while creating the sequence - oracle

Purpose of using Nextval while creating the sequence.

NEXTVAL returns the next value of a SEQUENCE number. A reference to NEXTVAL must be preceded by the SEQUENCE object name

NEXTVAL Example

If DEPTNO is a sequence number, we can create a new department name with:
INSERT INTO Student
(rollno, name, age)
VALUES
(rollno.NEXTVAL, 'Prashant', 15);
What is forall Statement? - oracle
What is forall Statement? - The FORALL binds input as a collection and sends them to the SQL engine for processing...
What is flashback Query? Explain its uses - oracle
What is flashback Query? - Oracle Flashback Query allows users to see a consistent view of the database as it was at a point in the past...
Tablespace purposes and significances - oracle
Tablespace purposes and significances - A tablespace is a logical container unit within an Oracle database. It does not exist physically on a filesystem...
Post your comment