Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle output to excel
D.J. Platt wrote:
> Database r via DBMonster.com wrote:
>
>> If your tables are not that big, then with spool create text file >> delimited >> (kind of csv) and then open it with excel. >> You can make a script that will spool data on the daily basis >> >> If tables contain a lot of data, then spooling can significantly slowdown >> database. You can try using some third party high-speed products like >> fastreader to extract data into csv : www.wisdomforce.com >> >> Murtuja wrote: >> >>> I want daily report in Excel format.and this excel file should be >>> mailed to client.I want autoamtic process for that just like cron job. >>> >>> I am using Oracle 9i on Linux >> >>