Re: ideas to use ora hash

create table t1 (x int);
insert into t1select rownum from all_objects where rownum <= 10;
insert into t1 select * from t1; -- t1 now has "duplicate" rows:
1,1,2,2,3,3, ...

select * from t1 minus select 15 from dual; -- t1 minus a non-existent t1 value

Run this.  You'll see that the minus on t1 (regardless of the set
you're "subtracting") will remove duplicate rows from t1.  That's what
I meant by saying "be careful with minus".  You might want this
behavior, or you might not -- it's entirely up to you to decide what
you consider "differences" between two tables (whether the existence
of extra rows in one table qualifies as a difference).

Glenn



On 3/22/06, Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:
> Thanks Glen, but I didn't got the idea could you give an example :) please.
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: