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
> --
> lorenzen_at_tiny.net | Life is complex; it has
> | real and imaginary parts
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.
Received on Tue Jun 16 1998 - 14:17:37 CDT
