Re: sqlplus and excel - beginners question!

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Wed, 25 Apr 2007 21:52:20 +0000 (UTC)
Message-ID: <f0oiik$tko$2@klatschtante.init7.net>

On 2007-04-25, 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?

If you're not bound to using SQL*Plus, maybe the following link helps: http://www.adp-gmbh.ch/blog/2007/02/01.php

Regards, RenÚ

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch

Received on Wed Apr 25 2007 - 16:52:20 CDT