Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Data comparison question
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