[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Oracle SQL developer -- accessing Microsoft database table ?

I setup the below links in my Oracle SQL developer.

http://total-bi.com/2010/11/using-oracle-sql-developer-with-ms-sql-server/
http://thinkoracle.blogspot.com/2010/09/using-oracle-sql-developer-with-ms-sql.html
http://djiang.wordpress.com/2007/02/27/using-oracle-sqldeveloper-to-access-sqlserver/

How can I do something like the below in Oracle SQL developer ?

  select *
  from Oracle_database_table
  Inner join Microsoft_database_table
0
finance_teacher
Asked:
finance_teacher
1 Solution
 
Helena Markováprogrammer-analystCommented:
I think that you have to create a database link - here is more about it:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5005.htm#i2061505
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now