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: ideas to use ora hash

Re: ideas to use ora hash

From: Glenn Santa Cruz <glenn.santacruz_at_gmail.com>
Date: Wed, 22 Mar 2006 14:52:55 -0600
Message-ID: <277902c40603221252hc48383es2439b12cf548f1c9@mail.gmail.com>


Be careful, though, when using minus -- it will remove duplicate rows.  This may be exactly the behavior you want, but you should at least consider what you're asking the database to do... If those rows are interesting to you, then minus isn't such a good candidate for comparisons.

On 3/22/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> The minus technique is the best I think to compare tables, but I think
> attractive the idea of the hash column.
<snip>

Glenn

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 22 2006 - 14:52:55 CST

Original text of this message

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