Try

SET HEAD OFF
SET VERI OFF
SET FEED OFF
SET ECHO OFF

spool x:\dba\db_monitor\get_sigtas_row_count.txt
select 'ACCT_STATEMENT_BALANCE', count(*) from
ACCT_STATEMENT_BALANCE;
select 'AGENCY_NOTICE', count(*) from AGENCY_NOTICE;

spool off

SET HEAD ON
SET VERI ON
SET FEED ON
SET ECHO ON


>From: "Denmark Weatherburne" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Re: How to suppress the row heading when spooling output to file
>Date: Fri, 31 May 2002 17:11:43 -0600
>
>Hi Listers,
>
>I'm spooling rowcounts from Oracle tables to a file, but I don't want
>the column headings spooled only the row values.
>Anybody knows the setting to turn off the heading output?
>
>This is an extract from the script generated:
>
>spool x:\dba\db_monitor\get_sigtas_row_count.txt
>select 'ACCT_STATEMENT_BALANCE', count(*) from ACCT_STATEMENT_BALANCE;
>select 'AGENCY_NOTICE', count(*) from AGENCY_NOTICE;
>
>This is an extract of the output:
>
>'TRACK_REVERSE_TRAN COUNT(*)
>------------------- ----------
>TRACK_REVERSE_TRANS 0
>
>
>'TRADE_TYP COUNT(*)
>---------- ----------
>TRADE_TYPE 4
>
>Thanks in advance for your advice.
>
>Regards,
>
>DW
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

Oracle LazyDBA home page