Oracle function " in " , " any ", " some " , " all "

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


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

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