CODE EXAMPLE FOR SQL

SQL Server OPENQUERY WITH result SETS

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