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!

whats difference between exists and in

user13310481Jul 6 2010 — edited Jul 6 2010
Hii experts
Could you tell me where should I opt IN and where to use EXISTS .I've tested it practically ,I dont find any difference among them execpt
the fact that NOT EXISTS will return null ,but NOT IN doesnt.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2010
Added on Jul 6 2010
5 comments
1,460 views