On Wed, 25 Apr 2007 21:11:59 +0200, sybrandb wrote:
> On 25 Apr 2007 10:15:59 -0700, ton de w <ton_de_winter_at_yahoo.co.uk>
> wrote:
>
>>Hello,
>>I am querying a table in Ora9i. It does have 100 + fields. I am
>>invoking sqlplus from a windows cmd box. This is temporary until toad is
>>installed. Have to make do with sqlplus/cmd window fro the moment. So
>>when I do a select * from table the output is unreadable. I can, and do,
>>redirect this to a file.
>>Can I redirect the output to, say, output.xls and then open this file in
>>excel - and have column heading and the field values underneath?
>>
>>TIA
>>
>>Ton
>
> Yes and no. You can create output in html (see SET MARKUP HML in your
> sqlplus manual) or you can dump the results of your query in csv format
> by using Tom Kytes procedure to dump the output of any select to csv
> (search for dump csv on http://asktom.oracle.com)
Also, SQL Developer, the new fancy Toad kisser from Oracle Corp. can
export results in all of the above formats: XML, XLS and HTML.
--
http://www.mladen-gogala.com
Received on Thu Apr 26 2007 - 23:30:21 CDT
