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
Search This Blog
Total Pageviews
Monday, 24 October 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment