I'm studying for my OCP, and have decided to do exam 1ZO-047 "Oracle Database SQL Expert" as one of my OCA exams.
I recently came across a question on the usage of ANY and SOME, which I have rarely, if ever encountered in my job, so I Googled and found this great explanation by Eddie Awad:
http://awads.net/wp/2005/08/09/any-some-and-all-in-oracle
