RE: spool file output

You need:

        SET ECHO OFF You may also want:

	SET PAGESIZE 0
            SET TRIMSPOOL ON

-
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com

> -----Original Message-----
> From: Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
> Sent: Friday, June 09, 2000 10:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: spool file output
>
> 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 -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, June 09, 2000 8:37 AM
>
>
> >
> > 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).
> >
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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 - 11:13:20 CDT