SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MINUS operator not giving exact result

465334Aug 8 2006 — edited Aug 8 2006

Hi ,

I am checking the data of two tables using MINUS operator but it is not providing correct result.
The problem is like

select count(*) from table1=111960
and
select count(*) from table2=102588
so
select * from table1 MINUS select * from table must give a resultset of 9372 rows or more.

How come it is returning less rows ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2006

Added on Aug 8 2006

8 comments

1,684 views