SQL Server Add Oracle Query Linkserver

EXEC master.dbo.sp_addlinkedserver @server = N ' Testlink ', @srvproduct =n ' Oracle ', @provider =n ' oraoledb.oracle ', @ Datasrc=n ' SOURCEORCN '
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname =n ' Testlink ', @useself =n ' False ', @locallogin =null, @rmtuser =n ' UserId ', @rmtpassword = ' Password '

In

Right-click Property in Server objects->linked servers->oraoledb.oracle--->allow inprocess check

Then use [Linkeserver]. [UserId]. [TableName]

Note: [Linkeserver]. [UserId]. [TableName] The UserID and TableName must all uppercase, and note that Linkserver is 2 points between the user name

SELECT * from Testlink. Userid. TABLENAME

Results are returned normally, and note that Oracle data is queried through the link server in SQL, using the SQL syntax of Oracle

SQL Server Add Oracle Query Linkserver