PL/SQL – Emailing the results of a query as HTML Table in the body of the email

I am firing a query on a table in pl/sql (Oracle 11g). It will result in some 10 rows with 5 columns.

How to send this data in the body of email as a HTML table?

Assume column names are col_name1, col_name2, col_name3, col_name4 and col_name5.

Can someone please help me with a sample code.


Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.