Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus and excel - beginners question!

Re: sqlplus and excel - beginners question!

From: <sybrandb_at_hccnet.nl>
Date: Wed, 25 Apr 2007 21:11:59 +0200
Message-ID: <8r9v23lj4s2j7gn2lfs7i5oqbr376ddpat@4ax.com>


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)

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Apr 25 2007 - 14:11:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US