raghu wrote:
> 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?
> The table has a few millions of records.
>
> Thank you.
>
DBMS_RECITFIER_DIFF built-in package
Demos in Morgan's Library at www.psoug.org
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Nov 17 2005 - 21:40:46 CST
