Re: spool off in SQL*Plus

From: Tom Cruise <tom_cruise_at_www.www>
Date: Thu, 31 Oct 2002 13:41:45 +0100
Message-ID: <apr8gu$b6i$1_at_sunce.iskon.hr>


"Jay O'Shea" <lacekdb_at_yahoo.com> wrote in message news:d2297645.0210301413.3ac0e28d_at_posting.google.com...
> I successfully spooled off a file into a fixed width text file using
> the spool/spool off set of commands isn sql plus. However, there is a
> heading before each group of records that came with the text field. Is
> there some way to spool off without getting what amounts to many rows
> of headings sprinkled throughout my data?
>
> Thanks in advance,
> Jay

Try these settings:

SET HEADING OFF;
SET FEEDBACK OFF;
SET PAGESIZE 0; TC Received on Thu Oct 31 2002 - 13:41:45 CET

Original text of this message