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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Verify data is identical methods - which is best?

RE: Verify data is identical methods - which is best?

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Mon, 28 Aug 2000 12:46:44 -0400
Message-Id: <10602.115654@fatcity.com>


using minus will be fastest .....

select * from new_results
minus
select * from old_results

this is assuming both tables have same structure ...

hth
Raj



Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. Received on Mon Aug 28 2000 - 11:46:44 CDT

Original text of this message

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