Skip to Main Content

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!

Issue with Minus Query

rkpJun 1 2012 — edited Jun 2 2012
Hello All,

I am using oracle database 10.2.0.4 in windows server.

I am doing data comparision for 2 set of query using the minus operator with same condition.
My 1st query is giving 23 rows and 2nd query is giving 20 rows. The output should be 3 rows, but I am not getting the same. It is returning null.

select WORK,WORK_UNIT,WORK_STR from WORK_GROUP
where WORK_UNIT=003
and WORK_STR=10
and WORK is null
MINUS
select WORK,WORK_UNIT,WORK_STR from WORK_GROUP@DBL_SOURCE
where WORK_UNIT=003
and WORK_STR=10
and WORK is null;

Any updates on the above query?

Thank You,

RKP
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2012
Added on Jun 1 2012
6 comments
1,729 views