Here I am giving an example to send an oracle database table data in csv/text file as mail attachment using a simple PL/SQL APIs. Step 1: Create a new procedure as below, which should take care of following actions, Convert table data into csv file. Save generated csv file to Oracle Directory. Send generated csv file as an attachment. CREATE OR REPLACE PROCEDURE table_data_to_csv_file (p_from IN VARCHAR2, p_to IN VARCHAR2, p_cc IN VARCHAR2, p_bcc IN VARCHAR2, p_file_location IN VARCHAR2, x_return_status out VARCHAR2, x_return_message out VARCHAR2) AS CURSOR cur_emp_data IS SELECT emp.empno,
by Karkuvelraja Thangamariappan ♠ (@tkarkuvelraja)