Re: SQL PLus Formatting
From: Harri Kaukovuo <harri.kaukovuo4_at_nic.fi>
Date: 17 Nov 2001 20:42:04 GMT
Message-ID: <9t6i2s$5b8$1_at_news1.song.fi>
Date: 17 Nov 2001 20:42:04 GMT
Message-ID: <9t6i2s$5b8$1_at_news1.song.fi>
"Michal Maik" <mikey66_at_mb.sympatico.ca> wrote in news:CtyJ7.1774$7b2.58391_at_news1.mts.net:
> In sql+, when I issue the spool command, is there a way to skip the
> next dozen or so lines ( the query ) that follow, in order to get just
> the output in the file im spooling to?
> Also, is there a way to spool to an .xls file without all the data
> going into one field? Thanks
Try this:
set verify off
set heading off
set pagesize 9999
set echo off
- Harri
Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4