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.

Potrebbero interessarti anche...

Lascia un commento

Il tuo indirizzo email non sarà pubblicato. I campi obbligatori sono contrassegnati *