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 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
Something like this? sends csv instead of xls but Excel can open it. Shell script is first. SQL second.
dj
---------------cut here-----------------------------#!/bin/sh
--------cut here ------------------------SET HEADING OFF
SELECT 'Table,Tablespace'
FROM DUAL; SELECT table_name,tablespace_name
FROM user_tables;
SPOOL OFF
exit
--------------cut here -------------------------Received on Wed Feb 08 2006 - 20:26:26 CST