Re: Sqlplus Question

This is how you do this:

SQL> COLUMN TODAY NEW_VALUE DAY
SQL> select sysdate today from dual;

The variable &DAY now has the value returned for SYSDATE and can be used elsewhere:

SQL> select name from tab where rec_date = '&DAY';

HTH 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 Mon Jun 29 1998 - 19:24:38 CDT