Oracle Glossary :ANY
The ANY comparison condition is used to compare a value to a list or subquery. It must be preceded by =, !=, >, <, <=, >= and followed by a list or subquery. When the ANY condition is followed by a list, the optimizer expands the initial condition to all elements of the list and strings them together with OR operators, as shown below. SELECT … fields … FROM … table … WHERE sal > ANY (2000, 3000, 4000); note: The SOME and ANY comparison conditions do exactly the same thing and are completely interchangeable.