Any Operator allows your take records that satisfy any one value in the
Criteria for example

Select * from emp where Deptno =Any (Select Deptno from Dept);

Even if one Dept from the Dept table is there in the emp table then the
Query is executed. The Above query will return 14 Rows.

Select * from emp where Deptno =All (Select Deptno from Dept);

Even if one dept does not exists in the dept table then no records are
fetched from the emp table. The above query returns 0 Rows.

HTH

Regards,
Ganesh R
Mantas Implementation Team
DID : (+65) 6231-8719
HP : (+65) 9067-8474
===========================================
Live to learn... forget... and learn again.
===========================================







"Michael Knox"
<michael.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
ply-ch.com> cc:
Subject: ANY ALL Guidance Required.
01/30/04 02:28 PM







Hi,

Does anyone have an idiots explanation as to the Oracle operators ANY &
ALL. I understand the IN operator though I am having trouble with the other
two. What is the difference?

Thanks,

Mike




--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:
http://www.lazydba.com/legal.html




---------------------------------------------------------------------------
This message (including any attachments) is confidential and may be
privileged. If you have received it by mistake please notify the sender by
return e-mail and delete this message from your system. Any unauthorised
use or dissemination of this message in whole or in part is strictly
prohibited. Please note that e-mails are susceptible to change.
ABN AMRO Bank N.V. (including its group companies) shall not be liable for
the improper or incomplete transmission of the information contained in
this communication nor for any delay in its receipt or damage to your
system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that
the integrity of this communication has been maintained nor that this
communication is free of viruses, interceptions or interference.
---------------------------------------------------------------------------



Oracle LazyDBA home page