How to write a update query in perl script?

Shell Programming and Scripting
1

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?

2

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