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>
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