Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sqlplus Question
Hi,
Declare a variable in SQLPLUS, select into this variable when selecting
from the sequence, and use this variable when refering to the value.
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.
Received on Tue Jun 16 1998 - 13:09:43 CDT