Re: sequence

Joe you are absolutely right
>From the sql reference : "Where to use currval and nextval ............If
any of these locations contains references to both CURRVAL and NEXTVAL, then Oracle increments the sequence and returns the same value for both CURRVAL and
NEXTVAL."
Sorry for the rtfm question. I am really lucky to learn from you all. Thanks list and a happy new year to you too.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 01, 2004 18:54

> Sounds like you need to read the docs on sequences, happy new year and
> happy reading.
>
> joe
>
> bulbultyagi_at_now-india.net.in wrote:
>
> >Hello list and a happy new year to everyone, why does :
> >
> >insert into test values (mysequence.nextval, mysequence.currval ) ;
> >
> >have the same effect as
> >
> >insert into test values (mysequence.currval, mysequence.nextval ) ;
> >
> >
> >
> >where
> >1. mysequence is
> >create sequence mysequence increment by 1 start with 1 maxvalue 1000
> >nocycle nocache ;
> >
> >and
> >
> >2. test is
> > Name Null? Type
> > -------------------- -------- ------------------------
> > ID NUMBER(7)
> > ID2 NUMBER
> >
> >
> >
>
> --
> Joseph S Testa
> Chief Technology Officer
> Data Management Consulting
> 614-791-9000
> It's all about the "CACHE"
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joe Testa
> INET: jtesta_at_dmc-it.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).