Re: oracle output to excel

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 2 Feb 2006 22:21:36 -0500
Message-ID: <hdydnT9zGe_eUX_eRVn-hg@comcast.com>

"Database r via DBMonster.com" <u2279_at_uwe> wrote in message news:5b4d1196946f3_at_uwe...
> 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

has anybody mentioned DBMS_JOB and UTL_SMTP yet?

the OP did specify scheduling and emailing, not just file format

++ mcs Received on Thu Feb 02 2006 - 21:21:36 CST