Automation script for Oracle queries for two different Databases


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Automation script for Oracle queries for two different Databases
# 1  
Old 03-21-2016
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..
# 2  
Old 03-23-2016
Hi All,

can any one please advise how can write the script.

Thanks,
Vasuv
# 3  
Old 03-23-2016
If you:
  1. show us the database commands you're using to extract data from your tables,
  2. show us a sample of the data that is extracted by those queries, and
  3. show us the results you are trying to get when you calculate differences based on that sample data,
you will be much more likely to get a response than making us guess at everything you might be trying to do.
Login or Register to Ask a Question

Previous Thread | Next Thread

3 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Automation Script for Oracle

Hi, As a Oracle Developer, I am writing many Procedures,Functions and Packages. Facing Many optimization issue after writing these Database objects. Trying to tune it manually. Can we write any Shell/Perl/Python script to Optimize these Database objects instead of doing manual check and... (1 Reply)
Discussion started by: vasuvv
1 Replies

2. Shell Programming and Scripting

script to find oracle databases that are not in cluster

I need to create a script to list all the databases that are in cluster environment. The reason is that there are databases which are not in under cluster control and we need to identify those. The easiest way to identify is: clrt list (if SUNW.oracle_server:6, SUNW.oracle_listener:5 are not... (0 Replies)
Discussion started by: misterx12345
0 Replies

3. UNIX and Linux Applications

Monitoring Tablespaces on Oracle Databases.

can anyone provide me with a basic command that can do this? like, is there a one liner command line i can run that will spit out some digits to me. (digits i can write a script to monitor)??? (0 Replies)
Discussion started by: SkySmart
0 Replies
Login or Register to Ask a Question