Re: ANY and SOME

In article <a4bchugl4brp1p8f5qlktsk10efo3m453o_at_4ax.com>, Martin says...
>
>On 23 Jun 2002 11:26:57 -0700, the living god Thomas Kyte
><tkyte_at_oracle.com> walked on earth to tell us this:
>
>>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....)
>
>You know, I was wondering about IS and AS too. Good to know.
>
>>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.
>
>But why oh why does Oracle feel the need for this redundancy? Are
>they trying to be SQL server compatible or something?

it actually predates the existence of SQL server by a good many years (our implementation of it and the fact that the language defines the constructs).

It is in the generic definition of the language that is SQL. If you want to be SQL compliant, you'll have both implemented.

>--
>Martin

--
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