Message-Id: <10525.108592@fatcity.com> From: "Gurgaon, DBA (CAP, GECSI, CONTRACTOR)" Date: Mon, 12 Jun 2000 11:30:37 +0530 Subject: RE: spool file output Thanks Every body for the help. Vikas C -----Original Message----- From: Guidry, Chris [mailto:chris.guidry@atcoelectric.com] Sent: Friday, June 09, 2000 10:55 PM To: Multiple recipients of list ORACLE-L Subject: 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@atcoelectric.com > -----Original Message----- > From: Ruth Gramolini [SMTP:rgramolini@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 > 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@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@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@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@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: Guidry, Chris INET: chris.guidry@atcoelectric.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@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