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

July 11, 2015 0 Comments

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.

Thanks,
Arjun

Source: oracle