Clarification on sequences example

From: Rajesh Bhave <rajeshb_at_india.hp.com>
Date: Tue, 10 Nov 1998 11:34:04 +0530
Message-ID: <3647D754.3C659C71@india.hp.com>

Hello

Psuedocolumn NEXTVAL increments the sequence and returns the new value. Consider following example from Oracle manual :

CREATE SEQUENCE eseq

INCREMENT BY 10 The first reference to ESEQ.NEXTVAL returns 1. Now, since the MINIMUM and START WITH parameters are omitted, value for both these clauses is 1 by default. Then, first reference to ESEQ.NEXTVAL must return 11 (1+10), isn't it. Is this mistyped in manual (reference should be for CURRVAL and not NEXTVAL ?) Please explain.

Thanks and Regards,
Rajesh Received on Tue Nov 10 1998 - 00:04:04 CST