Re: oracle output to excel

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

-- 
Message posted via http://www.dbmonster.com