Compare data between 2 tables (same columns) in different schemas

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Mon, 10 Aug 2015 13:33:20 -0300
Message-ID: <CAJdDhaPomrA=oXg0p4akYHv7iJm8FAugSnxJwc47AhXJ_ED-gg_at_mail.gmail.com>

Is there any Oracle resource to compare data between 2 tables (same columns) in different schemas ?

I use PL/SQL Developer. It does it.
But it requests a primary key in the table. Some tables does not have it.

Regards
Eriovaldo

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 10 2015 - 18:33:20 CEST

This message: [ Message body ]
Next message: Kenneth Naim: "RE: question about bigfile tablespaces at database create time."
Previous message: Alfredo Abate: "OT: Chicago Oracle Users Group Meeting - Sept 17th"
Next in thread: Stéphane Faroult: "Re: Compare data between 2 tables (same columns) in different schemas"
Reply: Stéphane Faroult: "Re: Compare data between 2 tables (same columns) in different schemas"
Reply: Adams, Matthew (GE Appliances): "RE: Compare data between 2 tables (same columns) in different schemas"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message