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