Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Data comparison question
I guess it should be enough. However, I'm afraid it won't work for the LONG columns.
Paul
<sergey_s_at_my-deja.com> wrote in message news:8meqa1$ui8$1_at_nnrp1.deja.com...
> I need to verify that two tables have exactly the same data. To do that
> I am planning the following:
>
> select * from T1
> MINUS
> select * from T2;
>
> and then
>
> select * from T2
> MINUS
> select * from T1;
>
> If I get no rows selected in both cases, will that be sufficient?
>
> Thank you!
>
> Sergey
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 04 2000 - 00:00:00 CDT