WELCOME ON BOARD - ORACLE
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment