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.

am05mhz · Accepted Answer · 2018-01-12 14:50:17Z

3

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]

answered Jan 12, 2018 at 14:50

am05mhz

2,9052 gold badges26 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Milen · Accepted Answer · 2014-03-05 07:08:58Z

1

try this:

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

answered Mar 5, 2014 at 7:08

Milen

8,8977 gold badges47 silver badges59 bronze badges