oracle同步数据，两张表结构相同且分布在不同数据库，具体场景如下，如何写SQL语句？

异构数据库的话，用db_link 和 Merge 吧 语法如下 : MERGE INTO [your table-name] [rename your table here] USING ( [write your query here] )[rename your query-sql and using just like a table] ON ([conditional expression here] AND [...]...) WHEN MATHED THEN [here yo