Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Sqlplus Question

Sqlplus Question

From: Phill Weiss <weiss_at_cig.mot.com>
Date: 16 Jun 1998 17:05:49 GMT
Message-ID: <6m68ld$1ij$3@trotsky.cig.mot.com>


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 - 12:05:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US