Just put these lines at the top of you script before spool xxxx.
SET HEADING OFF;
SET VERIFY OFF;
SET FEEDBACK OFF;
HTH,
Ruth
----- Original Message -----
From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) <DBA.Gurgaon_at_geind.GE.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, June 09, 2000 8:37 AM
Subject: spool file output
>
> Hi Every one
>
> Can anybody tell me how to remove
> sql>@cc.sql
> and
> sql> spool off
> (i.e first and the last line of my output file)
> from my output file,which is the result of spooling.
> where cc.sql is my script name.
> what parameter is to be set on sql prompt to remove these.
>
> thanks in advance
>
> Vikas
> --
> Author: Gurgaon, DBA (CAP, GECSI, CONTRACTOR)
> INET: DBA.Gurgaon_at_geind.GE.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).
Received on Fri Jun 09 2000 - 09:20:01 CDT
