Re: ideas to use ora hash

  • From: "Glenn Santa Cruz" <glenn.santacruz@xxxxxxxxx>
  • To: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
  • Date: Wed, 22 Mar 2006 14:52:55 -0600

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@xxxxxxxxx> 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


Other related posts: