Skip to Main Content
Forums

SQL & PL/SQL

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!

Sending formatted email

Salman QureshiMar 29 2010 — edited Mar 30 2010
Hi,
I am using oracle 10.2.0.4 database

Is there any one who can guide me that how to send a formatted email from oracle using UTL_SMTP package. For example, if i query dba_data_files view as follows
select file_name,bytes,autoextensible from dba_data_files;

Query returnts me a number of rows and i want to send this result through email same in the table format in which the query returns the result.

Thanks in advance.
This post has been answered by Hoek on Mar 30 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2010
Added on Mar 29 2010
2 comments
2,660 views