Comparison of two tables

Hi,

I was looking at an optimized way in pl/sql to compare the data from tables in two different databases (Oracle 9i). Is there any alternate to opening cursors for each of the two tables and looping through them?

Thank you.

Quote:

---

Originally Posted by raghu_vnin

Hi,

I was looking at an optimized way in pl/sql to compare the data from tables in two different databases (Oracle 9i). Is there any alternate to opening cursors for each of the two tables and looping through them?

Thank you.

---

select * from table_1
minus
select * from table_2
UNION ALL
select * from table_2
minus
select * from table_1

will do

Tamil

Use DBMS_RECTIFIER_DIFF package.

Sergey