Re: Using "SOME" in a subselect

Any idea as to what the advantage of SOME/ANY is over other forms?

AND p.refreshTimeStamp    = SOME
        (SELECT
                MAX(pa.refreshTimeStamp)
         FROM pymt pa
         WHERE compid = '12345666'



Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



On Thu, Dec 18, 2008 at 9:41 AM, McNary, Mark <Mark.McNary@xxxxxxx> wrote:

>  I found this in the 10g dox
>
>
> http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10759/conditions002.htm#sthref888
>
>
>
> Thanx,
>
>
>
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
> *-Mark McNary*
>
> -SENIOR DATABASE ADMINISTRATOR
>
> UMB Bank, n.a.
>
> 1008 Oak St.
>
> MS1170304
>
> Kansas City  MO 64106
>
> (816)860-1934(W)
>
> (816)213-3125(M)
>
> (816) 860-1774(F)
>
> mark.mcnary@xxxxxxx
>
> http://www.umb.com
>
> "We are the music makers.  We are the dreamers of dreams" ~Willy Wonka
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>
>
> -----Original Message-----
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sandra Becker
> *Sent:* Thursday, December 18, 2008 11:12 AM
> *To:* oracle-l
> *Subject:* Using "SOME" in a subselect
>
>
>
> I came across some code today that has the following:
>
> SELECT
>
> .
>
> .
>
> .
>
> WHERE
>
> .
>
> .
>
> .
>
>   AND p.refreshTimeStamp    = SOME
>         (SELECT
>                 MAX(pa.refreshTimeStamp)
>          FROM pymt pa
>          WHERE compid = '12345666'
>
>
>
> Can anyone tell me what the " = SOME" portion of the code does?  I've done
> some research, but can't find anything so far.
> --
> Sandy
> Transzap, Inc.
>
> ------------------------------------------------------------------------------
> NOTICE:  This electronic mail message and any attached files are 
> confidential.  The information is exclusively for the use of the individual 
> or entity intended as the recipient.  If you are not the intended recipient, 
> any use, copying, printing, reviewing, retention, disclosure, distribution or 
> forwarding of the message or any attached file is not authorized and is 
> strictly prohibited.  If you have received this electronic mail message in 
> error, please advise the sender by reply electronic mail immediately and 
> permanently delete the original transmission, any attachments and any copies 
> of this message from your computer system. Thank you.
>
> ==============================================================================
>
>

Other related posts: