Sqlplus question
From: Phill Weiss <weiss_at_cig.mot.com>
Date: 16 Jun 1998 17:02:29 GMT
Message-ID: <6m68f5$1ij$1_at_trotsky.cig.mot.com>
[Quoted] [Quoted] 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 - 19:02:29 CEST
Date: 16 Jun 1998 17:02:29 GMT
Message-ID: <6m68f5$1ij$1_at_trotsky.cig.mot.com>
[Quoted] [Quoted] 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 - 19:02:29 CEST