From SQL Server 2005, I am able to query a linked Oracle 10g database with this:
select * from openquery(dgo1,'select * from DGOUSER.HOUSEHOLD')
I'm trying to add a where clause
select * from openquery(dgtest,'select * from dgtable.house where upper(LAST_NAME) = 'SMITH' ')
The error I get is:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'SMITH'.
What do I have to correct to get the query to work?