Bob,
All of the options stated by people from this list are excellent.
One thing that was not mentioned was that Excel can read any type of text
file. It will notice that it is a text file, and will provide you with the
opportunity to declare what the column delimiter is.
What this means is
And do not forget to use ... WHERE ROWNUM65537 :-)))
JP
On Monday 23 September 2002 15:13, you wrote:
Bob,
All of the options stated by people from this list are excellent.
One thing that was not mentioned was that Excel can read any type of text
file. It will notice that it is a
I have never thought that I would ever suggest using GUI tool over a command line.
Perhaps there is a first time for everything.
So, may I add to the list of good advices: use T.O.A.D. from http://www.quest.com/toad/
Disclaimer: I am not in any form affiliated with Quest Software nor I try to
For small number of rows only.
JP
BTW: Free HTML report tool http://www.allroundautomations.com/bodyqr.html
On Monday 23 September 2002 16:23, you wrote:
I have never thought that I would ever suggest using GUI tool over a
command line. Perhaps there is a first time for everything.
So, may
This seems to be coming up a lot lately, and I've had to do it myself
recently.
This is fairly easy to do with Perl. I think I posted something about
this within the past month, so you may want to dig in the archives
for some details.
Jared
On Friday 20 September 2002 14:03, Aponte, Tony
You
don't need to get rid of the commas. A CSV file will automatically be read into
excel and all the commas will become a breakpoint for new columns. Or
alternatively a spooled output can be read into excel, it will open the format
wizard to specify the breakpoints for columns
But
the
-
From:
Naveen Nahata
To: Multiple recipients of list ORACLE-L
Sent: Saturday, September 21, 2002 7:08
AM
Subject: RE: Spool Oracle Tables into
Excel Format
You
don't need to get rid of the commas. A CSV file will automatically be read
into excel and all the commas will
Sure. Use ',' as colsep, and have file extension csv.
Jun
-Original Message-
Sent: Friday, September 20, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
All,
Is it possible to create Oracle reports into Excel
format ?
Is it possible to spool Oracle tables into Excel
format?
Title: RE: Spool Oracle Tables into Excel Format
There were some posts recently suggesting the spooling of the columns using a comma as a separator. But check out this article in XML Journal (http://www.syntelinc.com/syntel/english/0072/SYNT_XMLjrnl.pdf). It shows how to build
You can spool Oracle output into text files using SQL*Plus. Excel can
handle plain text and Comma Delimitted Text files.
RWB
Bob Robert [EMAIL PROTECTED]@fatcity.com on 09/20/2002 03:33:24 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of
10 matches
Mail list logo