Re: SQL PLus Formatting

you might set feedback off and delimiter to ',' for excel comma delimted format.

Harri Kaukovuo <harri.kaukovuo4_at_nic.fi> wrote in message news: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
>
>
Received on Fri Nov 30 2001 - 04:09:05 CET