Monday, November 23, 2009

How do I Select Oracle tables from Linked server (SQL Server)?

We can you use the below query to select Oracle tables.

SELECT * FROM OPENQUERY (linked server name,'SELECT * FROM TAB')

Use the below link to create Linked Server:
http://ragudba.blogspot.com/2009/11/how-to-create-sql-server-linked-server.html

No comments: