How to Query on Multiple Databases (Oracle and DB2)
Posted on 2009-05-18
I have 2 Oracle and 1 DB2 databases. let us say Oracle 1, Oracle 2 and DB2 1.
I need to select a record from Oracle 1 and verify its existance in both Oracle 2 and DB2 1, before returning the result of the query.
All databases have a key that I can use to link them.
so All I am asking how can treat all those 3 databases as one database and query against all of them to get the results I want ?
thank you much in advance, and any suggestions are highly appreciated.