Re: sqlplus and excel - beginners question!

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