Re: High volume table comparison in Oracle

h.manjunath_at_iflexsolutions.com (Manjunath) wrote in message news:<68c7ea85.0302232234.1286eb88_at_posting.google.com>...
> Hi,
> I have to compare two tables( Each column in row) in Oracle table.
> These table contains around 10 to 15 millions of record with each row
> contains around 60 column. I tried to compare this using PL/SQL But
> this is very slow. Is there any other ways to do this. Could you
> please send me the code for this ? One of my friend suggested to use
> Unix script ? But how to use Unix in this Scenario ?

Use MINUS (select ... minus select ...) if you want the difference between two tables, or INTERSECT if want what's in both tables. Received on Mon Feb 24 2003 - 15:01:04 CET