Re: How do I suppress the echo

On Sun, 22 May 2005 07:27:11 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>
>Can someone please tell me what I am doing wrong. I can't get it to
>suppress the command echo in the spool file or suppress the terminal output.
>I'm sure it's something dumb, but I've been struggling for hours on this and
>need help.
>
>
>==============================================================
>$ cat test.scr
>sqlplus user/pass_at_service <<SCRIPT
>set echo off
>set termout off
>spool test.out
>set trimspool on
>set echo off
>select sysdate from dual;
>spool off
>SCRIPT
>
>==============================================================
>$ ./test.scr
>
>SQL*Plus: Release 8.1.7.0.0 - Production on Sun May 22 03:20:57 2005
>
>(c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>Connected to:
>Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
>JServer Release 8.1.7.4.1 - Production
>
>SQL> SQL> SQL> SQL> SQL> SQL>
>SYSDATE
>---------
>22-MAY-05
>
>SQL> SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.1 -
>Prod
>uction
>JServer Release 8.1.7.4.1 - Production
>
>================================================================
>$ cat test.out
>SQL> set trimspool on
>SQL> set echo off
>SQL> select sysdate from dual;
>
>SYSDATE
>---------
>22-MAY-05
>
>SQL> spool off

sqlplus -s .... etc

IIRC this is in the manual.

--
Sybrand Bakker, Senior Oracle DBA