Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to export to excel and format and send email?

673719Feb 4 2009 — edited Feb 4 2009

Hi all,
I have an sql query that i need to run daily. My question is: how can i create a procedure to export the query result to an excel file with font Arial size 9 with all columns streched for best fit and also sent-it via email with subject and email text to an email address?

Thanks in advance for your help.

PS: if possible please provide examples :)

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2009

Added on Feb 4 2009

#general-database-discussions

11 comments

1,076 views