sam_sark
asked on
How do I access data from multiple databases in oracle
Hi
I want to implement SELECT, UPDATE and DELETE SQL statement that access data from multiple dateases. This datebases may be in the same server or remote locations.
For example
1)customer table may be in one location and product table in another loaction. I want to create a SQL that is
SELECT custmer_name, phone_no
FROM Customer, Product
WHERE order_id = product_id and product_nm="DUNLOP TIRE"
2)Need to update table Patient_info thats reside in two different locations server in different databases.
3) Should I be able to implement join queries in multiple databease?
If someone can help me out that would be great. Thanks in advance.
I want to implement SELECT, UPDATE and DELETE SQL statement that access data from multiple dateases. This datebases may be in the same server or remote locations.
For example
1)customer table may be in one location and product table in another loaction. I want to create a SQL that is
SELECT custmer_name, phone_no
FROM Customer, Product
WHERE order_id = product_id and product_nm="DUNLOP TIRE"
2)Need to update table Patient_info thats reside in two different locations server in different databases.
3) Should I be able to implement join queries in multiple databease?
If someone can help me out that would be great. Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept psvel's comment as answer
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
jpkemp
EE Cleanup Volunteer