Re: SQL PLus Formatting
From: Ted McCabe <theom_at_gte.net>
Date: Sun, 18 Nov 2001 07:20:28 GMT
Message-ID: <0jJJ7.1399$yx5.285044_at_dfiatx1-snr1.gtei.net>
Date: Sun, 18 Nov 2001 07:20:28 GMT
Message-ID: <0jJJ7.1399$yx5.285044_at_dfiatx1-snr1.gtei.net>
For .xls you need to use the dbms_xml... series of packages (8i, 9i). Check
the PL/SQL reference for how to.
HTH
tED
"Michal Maik" <mikey66_at_mb.sympatico.ca> wrote in message
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
>
>
Received on Sun Nov 18 2001 - 08:20:28 CET