Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Comparison of two tables

Comparison of two tables

From: raghu <raghu_vnin_at_yahoo.com>
Date: 17 Nov 2005 15:53:43 -0800
Message-ID: <1132271623.249203.306650@g44g2000cwa.googlegroups.com>


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. Received on Thu Nov 17 2005 - 17:53:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US