Oracle some,any ,all and in

some,any ,all and in



select 1
from dual
where 1 in (12,23,1,34);


1
----------
1


select 1
from dual
where 1 =any (12,23,1,34)

1
----------
1

select 1
from dual
where 1 > any (12,23,1,34)

no rows selected


"some" and "any" are same

select 1
from dual
where 1 > some (12,23,1,34)

no rows selected



select 1
from dual
where 1 < all (12,23,1,34)

no rows selected

SQL> ed
Wrote file afiedt.buf

select 1
from dual
where 1 < all (12,23,2,34)

1
----------
1