Dear Sir/Madam
Before I put forward my deal, I would like to share a brief synopsis about myself -
I am working with an IT Giant for more than 2.5 years, and has already delivered 3 projects within the stipulated time with Client appreciation. Currently I am working as a Oracle and UNIX Shell Script Developer for American Airlines in the same organization.
Please find below my understanding about the Project and the approach that I'll follow to deliver your requirement, correct me if my understanding is wrong -
1. A file need to store the Information of Column A,B,C from a Table and save it in a drive
My approach :- I'll be using the File operation in PL/SQL Stored Procedure.
2. You will have e-mail ID's stored in one Table, I'll have to share the information of Column A,B and C in a table format as e-mail body, to the respective e-mail IDs.
My approach :- I'll be using HTML to print the Column Information in the e-mail and use UTL_SMTP to transmit the e-mails
3. You need a daily Job in order to monitor the directory(M:\test ) and remove the files older than 6 months
My approach :- I'll develop a small shell script and schedule it in CRON
***Approaches might vary depending on the environment.
Benefits you'll receive from me-
* Experience of delivering projects seamlessly
* 9 AM - 11 PM IST Support for 7 days a week
* Free service/support for 1 month after the Delivery and even after the full payment.
Hope to hear from you soon.
Thanks & Regards,
Shyam Halder