Home » SQL & PL/SQL » SQL & PL/SQL » comparing two tables data
comparing two tables data [message #37190] Wed, 23 January 2002 12:04 Go to next message
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.
Re: comparing two tables data [message #37192 is a reply to message #37190] Wed, 23 January 2002 13:42 Go to previous message
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
Previous Topic: UTL_FILE
Next Topic: oracle stored procedures and JDBC result sets
Goto Forum:
  


Current Time: Mon Aug 02 10:47:43 CDT 2021