Re: spool command

The following command will turn off echoing

set hea off pages 0 lines 79 verify off echo off

You would issue this just before the spool command

>>> gfaktor_at_ecal.com 04/24/01 04:12PM >>>
Hi All!
It's is possible to spool just output of command , not command itself.

SQL> select sysdate from dual;

24-APR-01 SQL> save sys.sql
Created file sys.sql

SQL> spool test.sql
SQL> @sys.sql
SQL> spool off
SQL> ed test.sql

        SQL> @sys.sql

        24-APR-01


        SQL> spool off

I would like to have in my test.sql file just:
        24-APR-01.

Thanks.
Greg.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).