How can I query or retrieve data from multiple database servers using one query statement. (4302841)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How can I query or retrieve data from multiple database servers using one query statement.
Description

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?
Resolution

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.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title