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: ton de w <ton_de_winter_at_yahoo.co.uk>
Date: 3 May 2007 13:43:20 -0700
Message-ID: <1178225000.251982.6720@c35g2000hsg.googlegroups.com>


On 26 Apr, 17:27, gazzag <gar..._at_jamms.org> wrote:
> On 25 Apr, 18:15, ton de w <ton_de_win..._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
>
> Can you use iSQLPlus?
>
> HTH
>
> -g

Good suggestion - would avoid any involvement with visual basic ;-) - but no isqlplus with 9i Received on Thu May 03 2007 - 15:43:20 CDT

Original text of this message

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