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!

ANY and ALL Operators vs IN operator

user468Feb 24 2011 — edited Feb 24 2011
Hi all,
i'm in the middle of learning the sql functions & operators ,now i'm learning about subqueries.
i've learned abot the IN / NOT IN operator.now i'm kind of learning about the ANY & ALL .
which the first question is : do i need to delve into this operators ? does anyone really use the any & all operator ,
i'm asking cause ANY & ALL kind of confuses me vs the IN operator ?
Thanks in Advanced
Naama
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2011
Added on Feb 24 2011
7 comments
9,886 views