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 ?

select *
from tablea
intersect
select *
from tableb

will show all identical rows

select *
from tablea
minus
select *
from tableb

all different rows

No Pl/sql needed

Hth

Sybrand Bakker
Senior Oracle DBA Received on Mon Feb 24 2003 - 13:09:34 CET