CODE EXAMPLE FOR SQL

SQL Server run query on linked server

SELECT * FROM OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE name = ''NewTitle''');