如何在MySQL中将表与Oracle中的表联接 [英] How to JOIN a table in MySQL with a table in Oracle

问题描述

现在，我非常确定这是不可能的，但是我想1)确认这一点，以及2)听取其他选择.

Now, I'm pretty sure that it's not possible, but I want to 1) Confirm this, and 2) Hear alternatives.

我今天的解决方案是运行MySQL查询，然后使用其结果构造一个"NOT IN('value1'，'value2'，'value3')"字符串，在运行该字符串之前我将它附加到了Oracle查询上.相当麻烦，但它确实有效，并且到目前为止足够快.

My solution today was to run the MySQL query, then use its result to construct a "NOT IN ('value1', 'value2', 'value3')" string, which I tacked onto the Oracle query before running it. Rather cumbersome, but it worked, and it's fast enough so far.

解决此问题的典型方法是什么?

What is the typical way of solving this problem?

推荐答案

典型方法，假设使用Oracle& Oracle.允许MySQL数据库彼此通信，这将是在Oracle实例上创建数据库链接，然后连接到MySQL数据库: http://www.dba-oracle.com/t_how_create_database_link.htm

Typical way, assuming the Oracle & MySQL databases are allowed to talk to one another, would be to create a database link on the Oracle instance, connecting to the MySQL one: http://www.dba-oracle.com/t_how_create_database_link.htm

然后，您可以在Oracle中运行查询，就好像您只在单个数据库上工作一样.

Then you can run queries in Oracle as though you're only ever working on a single database...

这篇关于如何在MySQL中将表与Oracle中的表联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！