Re: Sqlplus Question

Phil;
  The "currval" is established on a session basis and it represents the current value for that session. If another session uses the same sequence, its "currval" is unique to that session. This is maintained on a session basis and commits will have no impact on it.

You may think of "currval" as a session variable.

James

In article <6m6gch$1ij$4_at_trotsky.cig.mot.com>, weiss_at_cig.mot.com (Phill Weiss) wrote:

>In article <lorenzen-ya02408000R1606981331550001_at_news.visi.com>,
lorenzen_at_tiny.net (James Lorenzen) writes:
>> In article <6m68ld$1ij$3_at_trotsky.cig.mot.com>, weiss_at_cig.mot.com (Phill
>> Weiss) wrote:
>>
>> >Is it possible to make a sqlplus query for the nextval of a sequence in one
>> >query, store the result in a variable, and use the variable in a subsequent
>> >sqlplus query? I don't want to have to use pl/sql to do this, only sqlplus.
>> >If this is possible, please enlighten me as to how I can go about it.
Thanks.
>>
>> Phill;
>> Use "currval" from the sequnce. This will return the current value of the
>> sequence afer "nextval" is used in the session.
>>
>> HTH
>> James

>I already thought of using currval but, what if someone else uses nextval
>just before I run my query? This is why nextval has to be stored in a variable.
--

lorenzen_at_tiny.net             | Life is complex; it has
                              |   real and imaginary parts