Hopefully, the following questions are sensible:
Is it possible to use SQL to simultaneously query databases that are located in different places on the network?
Is it possible to create a "virtual table" or "temporary table" that consist of all the tables from the various databases that is needed in the query and then query "one table" instead of sequentially accessing each and every database?
For example, There are two separate databases that I query on a daily basis, an Oracle Database within the Hospital Contract Management Application and an Oracle Database within the Enterprise Warehouse.
Now, the password utilized to access each database is different.
Thanks in advance for insight!