Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

minus is not working

prakashMar 29 2011 — edited Mar 29 2011
Hi all,

can any one tell me how minus works.



(SELECT edi_trnsctn_type_name, meta_data_cid, meta_data_name, clm_source_code,
document_level_qlfr, target_column
FROM temp_tdc)
minus
(SELECT edi_trnsctn_type_name, meta_data_cid, meta_data_name, clm_source_code,
document_level_qlfr, target_column
FROM temp_midev);



first query return 425 rows
second query returns 421 rows

If i execute the above query it has to give four rows ,but it is giving 296 rows please help me.
I should find those 4 rows .
thank you
Regards,
P Prakash

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 26 2011
Added on Mar 29 2011
12 comments
861 views