Data difference

Does anyone know of any free tool or script that will let me compare the data between 2 tables and give the difference ? Thanks.

dbms_rectifier_diff package under SYS schema.

Enjoy,
Sergey

Quote:

---

Originally posted by rshivagami
Does anyone know of any free tool or script that will let me compare the data between 2 tables and give the difference ? Thanks.

---

Free tool = SQL
Free script depends on what differences you are looking for.

Code:

---

SQL> select * from t1;

        ID
----------
        1
        3
        5

SQL> select * from t2 ;

        ID
----------
        1
        2

SQL>
  1  select *
  2  from ( (select * from t1 minus select * from t2)
  3        union all
  4        (select * from t2 minus select * from t1)
  5*    )
SQL> /

        ID
----------
        3
        5
        2

SQL> spool off

---