8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for ALL, ANY and SOME Comparison Conditions in SQL

ALL, ANY and SOME Comparison Conditions in SQL - A quick look at some comparison conditions you may not be used to seeing in SQL against an Oracle database.

shawn said...

Excellent article.
Excellent in depth explanation.
Really hard to find, as rarely as these operators are used:-)

shakib said...

Thanks for posting, this post solve my problems.

Prasad said...

Excellent notes
one question
is not valid case in case of characters
Let us know

Tim... said...


Think about it. How is it possible for a column to be valid to multiple values? Using "= ALL" does not make sense because it would always be false unless all values in the ALL clause were the same.



Jannie said...

Thanks for this excellent explanation
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired