Re: Question on SQLPLUS (to store query results in a file)

In article <01bbc042$ccaec180$179fdd8e_at_jlaferriere.ey.ca>,

   "ERNST & YOUNG" <jlaferri_at_ey.ca> wrote:
>I set what it is needed to spool the output on a file. All is
>working ok, except that my output also appear in my
>log file. I dont want my output in the log file, but only in
>the file where I spool.

from the shell, use:
sqlplus -s scott/tiger <<EOF
set termout off
..
spool file.xxx
..
EOF

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.