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 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 enforce or market its products. I have just > found that I am too lazy to use SQL*Plus all the time. > > inka > > -----Original Message----- > Sent: Monday, September 23, 2002 9:13 AM > To: Multiple recipients of list ORACLE-L > > > 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 that you can use any character as a field delimiter, > tell Excel what that column is, and it will convert the file for you. > > By default, Excel likes the TAB char as a column delimiter. So, you can > write your query as such: > > select column1||char(10)||column2||char(10)||column3||char(10) from > table_name. > > Spool the output and name the file newfile.txt; start Excel, and file|open > the file and follow the help wizard. I do this all the time. > > Hope this helps. > > Tom Mercadante > Oracle Certified Professional > > > -----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? > > Thanks in Advance > Bob > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ ----------------------------- Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
