Comparison of two tables

Giganews Newsgroups
Subject: Comparison of two tables
Posted by:  raghu (raghu_vn…
Date: 17 Nov 2005


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?
The table has a few millions of records.

Thank you.