Re: Help, please. Unneeded variable replacement verbiage spooled to output file.

On 30 Apr 2007 13:07:43 -0700, Greg <esabens_at_yahoo.com> wrote:

>Anyway, this works great, except that the file that is output contains
>two lines at the beginning that show how the variables, backday and
>today, have been replaced. I'd really rather not have that showing in
>the export file. Following is an example of the lines I'm seeing that
>I don't need in the file (starting with 'old 37:' and 'new 37:'):
>
>----------
>old 37: and x.apptdate between '&backday' and '&today'
>new 37: and x.apptdate between '27-APR-07' and '29-APR-07'
>WEST LAFAYETTE,IN
>LAFAYETTE,IN
>LAFAYETTE,IN
>...
>...
>...
>... and so on ...
>----------
>
>Is there an SQL*Plus setting that I can change so that such verbiage
>isn't spooled?

set verify off

 Or, are their other options that I haven't learned yet
>that would make setting the dates in the second query's WHERE clause
>easier?

IMO, you don't need &backdate etc as they are derived from sysdate. I would 'merge' the calculation of those two dates in the final sql statement.

-- 
Sybrand Bakker
Senior Oracle DBA