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 *
from emp;"|
sqlplus
-M "HTML ON" -s scott/tiger|
uuencode emp.xls|
mail dba@remote-dba.net
Another approach us to use
Excel-DB for Oracle,
which has a built-in APU to quickly e-mail Oracle output as an excel
spreadsheet.
|
|
 |
|
Get the Complete
Oracle Tuning Details
The landmark book
"Oracle
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:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
| |
| |
Copyright ©
1996 -2017 by Burleson. All rights reserved.
Oracle® is the registered trademark of Oracle
Corporation. SQL Server® is the registered trademark of Microsoft
Corporation.
Many of the designations used by computer vendors to distinguish their
products are claimed as Trademarks
|
|
