Regresar
-
Título
How can I query or retrieve data from multiple database servers using one query statement. -
Descripción
How can I query to retrieve data from multiple database servers. How can I run a query for many different databases in one query or in one time?
-
Resolución
Create and use “DB Links” in your SQL statement query. Toad for Oracle provides a GUI for creating DB Links. Please go to the Schema Browser | DB Links Tab | click on the ‘Create DB Link’ icon. After creating a DB Link, you can use it or incorporate it in your SQL query.