how to query oracle database in SQL linked server

Question

I linked ORACLE Database in my local sql server called X.

ORACLE database : Y

ORACLE table name : PS.PSDBOWNER

SQL SERVER Name: X

I tried below query in my SSMS

select * from [X].[Y].[PS].[PSDBOWNER]

But its not working, Please let me know the correct syntax.

Answer 1

for those who is still looking for an answer to this question, that is to query oracle linked server in sql server, use a select statement like this:

select * from [oracle-linked-server-name]..[oracle-table-owner].[oracle-table-name]

Answer 2

try this:

SELECT * FROM X.Y.dbo.[PS.PSDBOWNER]