can any one suggest me on how to write a update query in perl script for Oracle database and also tell me abt how we can write a code for sending mails with report as attachment to appropriate persons?
The pre-requisite is you must have DBI and DBD::Oracle installed.
Go through the below url, you can find the answer
Perl Database Management - DBI, DBD and OraPerl
For sending attachment in mail you can use
-a
switch in mailx
mailx -a /path/to/attachament -s subject user@org.com
1 Like