How to format and send html email using utl_smtp
Hi,
I need to send email in the html format from within the database using utl_smtp. I am really not interested in creating os level file using "set markup html on spool on" and sending that as an html attachment. Can someone please give a code?
1. Output of a select needs to be emailed (for example : select empid, name from emp, salary)
2. Certian cells for example salary < 4800 needs to be higlighted in Red color
3. I need to send email which is having more than 32767 characters (I can not use varchar2 field)
I have reffered to following url on asktom:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1739411218448
However it does not help.
If someone has a sample code with any select from a table, it would be a great help.
Regards
Sudhanshu Bhandari