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
finance_teacherAsked:
Who is Participating?
 
Helena MarkováConnect With a Mentor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.