OraFAQ Forum: SQL & PL/SQL » comparing two tables data

Home » SQL & PL/SQL » SQL & PL/SQL » comparing two tables data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

comparing two tables data [message #37190]

Wed, 23 January 2002 12:04

Subra
Messages: 5
Registered: December 2000

Junior Member

Is there any utility to compare data in two different schemas in
Oracle.
For eg I have schema A -> table A and Schema B -> table A.
I would like to compare table A in both these schemas to know if anything changed or if they are the same.
The table in both the schemas have exactly the same structure. The data in it could be same or different.

Report message to a moderator

Re: comparing two tables data [message #37192 is a reply to message #37190]

Wed, 23 January 2002 13:42

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You'll need to run both of these (a - b, b - a):

select *
  from a.a
minus
select *
  from b.a

and

select *
  from b.a
minus
select *
  from a.a

Report message to a moderator

Previous Topic:	UTL_FILE
Next Topic:	oracle stored procedures and JDBC result sets

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 11:25:13 CDT 2024