Hi All,
I am using Oracle database. I am looking at a way or to see is there a way to access two databases having same schema but different data in the tables. I would like to access tables in two database and combine the result or if not possible to have the query output in order.
For eg: Let us say, we have database 1 (DB1) and databse 2 (DB2). As I told, the schema used in both the DBs is same. Let us say there is an Employees table in both the databases DB1 and DB2 but having different data values. One is from let us say Accounts section and another is from Sales section. Now I want to access both the Tables in these 2 DBs and combine the result. If combining is not possible then show values of Table DB1 followed by values of Table in DB2.
Need some pointers to understand and achieve this. Any help is really apppreciated.
Thanks in advance.