Oracle Equivalent of OPENQUERY

[Bonediggler1]

Hi-

I am wondering how to query one Oracle server from another. I used to do this via OPENQUERY in T-SQL, but am not sure how to do it in Oracle. I do not have admin rights to either, so I can't create any db objects. The syntax is roughly:

SELECT * FROM
ORA1.DB1 A INNER JOIN
(SELECT BLAH FROM ORA2.DB1) B
ON A.BLAH = B.BLAH

Thank you!!

 

[Turkbear]

Hi,
As your DBA to create a database link on the server you connect to ....( That is the only way to query multiple Oracle instances unless the DBA would create some views of the remote tables you need - these would use a database link as well but the DBA may prefer to keep that link private).






To Paraphrase:"The Help you get is proportional to the Help you give.."