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" <[EMAIL PROTECTED]> Sent: Thursday, January 01, 2004 18:54 > Sounds like you need to read the docs on sequences, happy new year and > happy reading. > > joe > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).