Query Oracle from SQL Server w/o a permanent Linked Server entry

Need to query a table on an Oracle box from SQL Server?

If your DBA won't let you create a linked server, this option may work for you. You'll need hard code your credentials in :(.



SELECT *
FROM OPENROWSET('MSDAORA',
'DATABASE_NAME';
'USER_TO_CONNECT_AS';'USER_PASS', 'select * from dual')
AS test