Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle output to excel
"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