03-21-2016
37,
0
Join Date: Apr 2012
Last Activity: 1 October 2018, 1:02 AM EDT
Posts: 37
Thanks Given: 8
Thanked 0 Times in 0 Posts
Automation script for Oracle queries for two different Databases
Hi Team,
I am Oracle Databse developer. I am currently working on two databases.
DB1 and DB2.
in DB1 I have a Select query which will return 100 records.
In Db2 I have a Select query which also return 100 records.
In these two tables ( in different Schemas) we have a common column.
Once after execution we will calculate the difference between these two columns.
After that we will send this result set to respective mail group.
This is the activity we will do manually 4th Tuesday of every month at 10AM CST.
Now I would like to automate this process using shell script. can any one please advise how to write the script for this process.
Many thanks.
Vasuv
Last edited by vasuvv; 03-21-2016 at 11:41 AM..