i am accessing oracle table information and feeding into my local sql server db. So in order to do that i have a SP written in sql server. Now my question is how to exactly write the logic to access the remote oracle DB
I have oracle ODBC connection created by "DSN = van_mart" and "tns service_name = mart" and "oraacleDB = orcdb82"
In sql server we qualify it by linkedservername.tablename, but i am not sure how to do for oracle.
From the example below customers and vendors are 2 oracle tables. Please correct the below syntax
FROM CUSTOMERS C WITH(NOLOCK) INNER JOIN [van_mart].[VENDORS] V
ON C.VID = V.VID
WHERE C.LAST_CHANGED >= @START_DATE AND C.LAST_CHANGED < @START_DATE+1 AND C.LAST_CHANGED < @END_DATE
Please let me know if you have any questions.