Re: ANY and SOME

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 23 Jun 2002 11:26:57 -0700
Message-ID: <af53th03aj@drn.newsguy.com>

In article <2e2chusvpqqt79poqaccllqrbkbdgb9b31_at_4ax.com>, Martin says...
>
>Is there a difference between ANY and SOME? I can't find any, but when
>there are two operators, it seems logical that they would have
>different behaviors.

you mean like "<>" and "!="
or "is" and "as" (create procedure p IS... create procedure p AS....)

any and some are synonymous with eachother. If you are "greater then ANY ...", you are "greater then SOME" and so forth. They have the same behavior.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sun Jun 23 2002 - 13:26:57 CDT