By Laurent Schneider
Here is how to invoke SQL*Plus script that accepts the output of
an Oracle SQL statement and e-mails it as an xls Excel spreadsheet:
echo "select *
-M "HTML ON" -s scott/tiger|
Another approach us to use
Excel-DB for Oracle,
which has a built-in APU to quickly e-mail Oracle output as an excel
Get the Complete
Oracle Tuning Details
The landmark book
Tuning: The Definitive Reference Second Edition" has been
updated with over 1,150 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle 11g
performance and you can
buy it for 40% off directly from the publisher.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA
1996 -2011 by Burleson Enterprises. All rights reserved.
Oracle® is the registered trademark of Oracle
Corporation. SQL Server® is the registered trademark of Microsoft
Many of the designations used by computer vendors to distinguish their
products are claimed as Trademarks