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 LazyDBA home page